| | 66 | <sect1 id="release-8-1-14"> |
|---|
| | 67 | <title>Release 8.1.14</title> |
|---|
| | 68 | |
|---|
| | 69 | <note> |
|---|
| | 70 | <title>Release date</title> |
|---|
| | 71 | <simpara>2008-09-22</simpara> |
|---|
| | 72 | </note> |
|---|
| | 73 | |
|---|
| | 74 | <para> |
|---|
| | 75 | This release contains a variety of fixes from 8.1.13. |
|---|
| | 76 | For information about new features in the 8.1 major release, see |
|---|
| | 77 | <xref linkend="release-8-1"/>. |
|---|
| | 78 | </para> |
|---|
| | 79 | |
|---|
| | 80 | <sect2> |
|---|
| | 81 | <title>Migration to Version 8.1.14</title> |
|---|
| | 82 | |
|---|
| | 83 | <para> |
|---|
| | 84 | A dump/restore is not required for those running 8.1.X. |
|---|
| | 85 | However, if you are upgrading from a version earlier than 8.1.2, |
|---|
| | 86 | see the release notes for 8.1.2. |
|---|
| | 87 | </para> |
|---|
| | 88 | |
|---|
| | 89 | </sect2> |
|---|
| | 90 | |
|---|
| | 91 | <sect2> |
|---|
| | 92 | <title>Changes</title> |
|---|
| | 93 | |
|---|
| | 94 | <itemizedlist> |
|---|
| | 95 | |
|---|
| | 96 | <listitem> |
|---|
| | 97 | <para> |
|---|
| | 98 | Widen local lock counters from 32 to 64 bits (Tom) |
|---|
| | 99 | </para> |
|---|
| | 100 | |
|---|
| | 101 | <para> |
|---|
| | 102 | This responds to reports that the counters could overflow in |
|---|
| | 103 | sufficiently long transactions, leading to unexpected <quote>lock is |
|---|
| | 104 | already held</quote> errors. |
|---|
| | 105 | </para> |
|---|
| | 106 | </listitem> |
|---|
| | 107 | |
|---|
| | 108 | <listitem> |
|---|
| | 109 | <para> |
|---|
| | 110 | Fix possible duplicate output of tuples during a GiST index scan (Teodor) |
|---|
| | 111 | </para> |
|---|
| | 112 | </listitem> |
|---|
| | 113 | |
|---|
| | 114 | <listitem> |
|---|
| | 115 | <para> |
|---|
| | 116 | Add checks in executor startup to ensure that the tuples produced by an |
|---|
| | 117 | <command>INSERT</command> or <command>UPDATE</command> will match the target table's |
|---|
| | 118 | current rowtype (Tom) |
|---|
| | 119 | </para> |
|---|
| | 120 | |
|---|
| | 121 | <para> |
|---|
| | 122 | <command>ALTER COLUMN TYPE</command>, followed by re-use of a previously |
|---|
| | 123 | cached plan, could produce this type of situation. The check protects |
|---|
| | 124 | against data corruption and/or crashes that could ensue. |
|---|
| | 125 | </para> |
|---|
| | 126 | </listitem> |
|---|
| | 127 | |
|---|
| | 128 | <listitem> |
|---|
| | 129 | <para> |
|---|
| | 130 | Fix <literal>AT TIME ZONE</literal> to first try to interpret its timezone |
|---|
| | 131 | argument as a timezone abbreviation, and only try it as a full timezone |
|---|
| | 132 | name if that fails, rather than the other way around as formerly (Tom) |
|---|
| | 133 | </para> |
|---|
| | 134 | |
|---|
| | 135 | <para> |
|---|
| | 136 | The timestamp input functions have always resolved ambiguous zone names |
|---|
| | 137 | in this order. Making <literal>AT TIME ZONE</literal> do so as well improves |
|---|
| | 138 | consistency, and fixes a compatibility bug introduced in 8.1: |
|---|
| | 139 | in ambiguous cases we now behave the same as 8.0 and before did, |
|---|
| | 140 | since in the older versions <literal>AT TIME ZONE</literal> accepted |
|---|
| | 141 | <emphasis>only</emphasis> abbreviations. |
|---|
| | 142 | </para> |
|---|
| | 143 | </listitem> |
|---|
| | 144 | |
|---|
| | 145 | <listitem> |
|---|
| | 146 | <para> |
|---|
| | 147 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 148 | running on a 64-bit platform (Tom) |
|---|
| | 149 | </para> |
|---|
| | 150 | </listitem> |
|---|
| | 151 | |
|---|
| | 152 | <listitem> |
|---|
| | 153 | <para> |
|---|
| | 154 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 155 | </para> |
|---|
| | 156 | </listitem> |
|---|
| | 157 | |
|---|
| | 158 | <listitem> |
|---|
| | 159 | <para> |
|---|
| | 160 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 161 | ON</literal> query (Tom) |
|---|
| | 162 | </para> |
|---|
| | 163 | </listitem> |
|---|
| | 164 | |
|---|
| | 165 | <listitem> |
|---|
| | 166 | <para> |
|---|
| | 167 | Fix planner bug with nested sub-select expressions (Tom) |
|---|
| | 168 | </para> |
|---|
| | 169 | |
|---|
| | 170 | <para> |
|---|
| | 171 | If the outer sub-select has no direct dependency on the parent query, |
|---|
| | 172 | but the inner one does, the outer value might not get recalculated |
|---|
| | 173 | for new parent query rows. |
|---|
| | 174 | </para> |
|---|
| | 175 | </listitem> |
|---|
| | 176 | |
|---|
| | 177 | <listitem> |
|---|
| | 178 | <para> |
|---|
| | 179 | Fix planner to estimate that <literal>GROUP BY</literal> expressions yielding |
|---|
| | 180 | boolean results always result in two groups, regardless of the |
|---|
| | 181 | expressions' contents (Tom) |
|---|
| | 182 | </para> |
|---|
| | 183 | |
|---|
| | 184 | <para> |
|---|
| | 185 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 186 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 187 | <literal>IS NULL</literal>. |
|---|
| | 188 | </para> |
|---|
| | 189 | </listitem> |
|---|
| | 190 | |
|---|
| | 191 | <listitem> |
|---|
| | 192 | <para> |
|---|
| | 193 | Fix PL/PgSQL to not fail when a <literal>FOR</literal> loop's target variable |
|---|
| | 194 | is a record containing composite-type fields (Tom) |
|---|
| | 195 | </para> |
|---|
| | 196 | </listitem> |
|---|
| | 197 | |
|---|
| | 198 | <listitem> |
|---|
| | 199 | <para> |
|---|
| | 200 | Fix PL/Tcl to behave correctly with Tcl 8.5, and to be more careful |
|---|
| | 201 | about the encoding of data sent to or from Tcl (Tom) |
|---|
| | 202 | </para> |
|---|
| | 203 | </listitem> |
|---|
| | 204 | |
|---|
| | 205 | <listitem> |
|---|
| | 206 | <para> |
|---|
| | 207 | Fix PL/Python to work with Python 2.5 |
|---|
| | 208 | </para> |
|---|
| | 209 | |
|---|
| | 210 | <para> |
|---|
| | 211 | This is a back-port of fixes made during the 8.2 development cycle. |
|---|
| | 212 | </para> |
|---|
| | 213 | </listitem> |
|---|
| | 214 | |
|---|
| | 215 | <listitem> |
|---|
| | 216 | <para> |
|---|
| | 217 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 218 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 219 | </para> |
|---|
| | 220 | </listitem> |
|---|
| | 221 | |
|---|
| | 222 | <listitem> |
|---|
| | 223 | <para> |
|---|
| | 224 | Fix <application>pg_ctl</application> to properly preserve postmaster |
|---|
| | 225 | command-line arguments across a <literal>restart</literal> (Bruce) |
|---|
| | 226 | </para> |
|---|
| | 227 | </listitem> |
|---|
| | 228 | |
|---|
| | 229 | <listitem> |
|---|
| | 230 | <para> |
|---|
| | 231 | Update time zone data files to <application>tzdata</application> release 2008f (for |
|---|
| | 232 | DST law changes in Argentina, Bahamas, Brazil, Mauritius, Morocco, |
|---|
| | 233 | Pakistan, Palestine, and Paraguay) |
|---|
| | 234 | </para> |
|---|
| | 235 | </listitem> |
|---|
| | 236 | |
|---|
| | 237 | </itemizedlist> |
|---|
| | 238 | |
|---|
| | 239 | </sect2> |
|---|
| | 240 | </sect1> |
|---|
| | 241 | |
|---|
| | 4057 | |
|---|
| | 4058 | <sect1 id="release-8-0-18"> |
|---|
| | 4059 | <title>Release 8.0.18</title> |
|---|
| | 4060 | |
|---|
| | 4061 | <note> |
|---|
| | 4062 | <title>Release date</title> |
|---|
| | 4063 | <simpara>2008-09-22</simpara> |
|---|
| | 4064 | </note> |
|---|
| | 4065 | |
|---|
| | 4066 | <para> |
|---|
| | 4067 | This release contains a variety of fixes from 8.0.17. |
|---|
| | 4068 | For information about new features in the 8.0 major release, see |
|---|
| | 4069 | <xref linkend="release-8-0"/>. |
|---|
| | 4070 | </para> |
|---|
| | 4071 | |
|---|
| | 4072 | <sect2> |
|---|
| | 4073 | <title>Migration to Version 8.0.18</title> |
|---|
| | 4074 | |
|---|
| | 4075 | <para> |
|---|
| | 4076 | A dump/restore is not required for those running 8.0.X. |
|---|
| | 4077 | However, if you are upgrading from a version earlier than 8.0.6, |
|---|
| | 4078 | see the release notes for 8.0.6. |
|---|
| | 4079 | </para> |
|---|
| | 4080 | |
|---|
| | 4081 | </sect2> |
|---|
| | 4082 | |
|---|
| | 4083 | <sect2> |
|---|
| | 4084 | <title>Changes</title> |
|---|
| | 4085 | |
|---|
| | 4086 | <itemizedlist> |
|---|
| | 4087 | |
|---|
| | 4088 | <listitem> |
|---|
| | 4089 | <para> |
|---|
| | 4090 | Widen local lock counters from 32 to 64 bits (Tom) |
|---|
| | 4091 | </para> |
|---|
| | 4092 | |
|---|
| | 4093 | <para> |
|---|
| | 4094 | This responds to reports that the counters could overflow in |
|---|
| | 4095 | sufficiently long transactions, leading to unexpected <quote>lock is |
|---|
| | 4096 | already held</quote> errors. |
|---|
| | 4097 | </para> |
|---|
| | 4098 | </listitem> |
|---|
| | 4099 | |
|---|
| | 4100 | <listitem> |
|---|
| | 4101 | <para> |
|---|
| | 4102 | Add checks in executor startup to ensure that the tuples produced by an |
|---|
| | 4103 | <command>INSERT</command> or <command>UPDATE</command> will match the target table's |
|---|
| | 4104 | current rowtype (Tom) |
|---|
| | 4105 | </para> |
|---|
| | 4106 | |
|---|
| | 4107 | <para> |
|---|
| | 4108 | <command>ALTER COLUMN TYPE</command>, followed by re-use of a previously |
|---|
| | 4109 | cached plan, could produce this type of situation. The check protects |
|---|
| | 4110 | against data corruption and/or crashes that could ensue. |
|---|
| | 4111 | </para> |
|---|
| | 4112 | </listitem> |
|---|
| | 4113 | |
|---|
| | 4114 | <listitem> |
|---|
| | 4115 | <para> |
|---|
| | 4116 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 4117 | running on a 64-bit platform (Tom) |
|---|
| | 4118 | </para> |
|---|
| | 4119 | </listitem> |
|---|
| | 4120 | |
|---|
| | 4121 | <listitem> |
|---|
| | 4122 | <para> |
|---|
| | 4123 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 4124 | </para> |
|---|
| | 4125 | </listitem> |
|---|
| | 4126 | |
|---|
| | 4127 | <listitem> |
|---|
| | 4128 | <para> |
|---|
| | 4129 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 4130 | ON</literal> query (Tom) |
|---|
| | 4131 | </para> |
|---|
| | 4132 | </listitem> |
|---|
| | 4133 | |
|---|
| | 4134 | <listitem> |
|---|
| | 4135 | <para> |
|---|
| | 4136 | Fix planner to estimate that <literal>GROUP BY</literal> expressions yielding |
|---|
| | 4137 | boolean results always result in two groups, regardless of the |
|---|
| | 4138 | expressions' contents (Tom) |
|---|
| | 4139 | </para> |
|---|
| | 4140 | |
|---|
| | 4141 | <para> |
|---|
| | 4142 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 4143 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 4144 | <literal>IS NULL</literal>. |
|---|
| | 4145 | </para> |
|---|
| | 4146 | </listitem> |
|---|
| | 4147 | |
|---|
| | 4148 | <listitem> |
|---|
| | 4149 | <para> |
|---|
| | 4150 | Fix PL/Tcl to behave correctly with Tcl 8.5, and to be more careful |
|---|
| | 4151 | about the encoding of data sent to or from Tcl (Tom) |
|---|
| | 4152 | </para> |
|---|
| | 4153 | </listitem> |
|---|
| | 4154 | |
|---|
| | 4155 | <listitem> |
|---|
| | 4156 | <para> |
|---|
| | 4157 | Fix PL/Python to work with Python 2.5 |
|---|
| | 4158 | </para> |
|---|
| | 4159 | |
|---|
| | 4160 | <para> |
|---|
| | 4161 | This is a back-port of fixes made during the 8.2 development cycle. |
|---|
| | 4162 | </para> |
|---|
| | 4163 | </listitem> |
|---|
| | 4164 | |
|---|
| | 4165 | <listitem> |
|---|
| | 4166 | <para> |
|---|
| | 4167 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 4168 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 4169 | </para> |
|---|
| | 4170 | </listitem> |
|---|
| | 4171 | |
|---|
| | 4172 | <listitem> |
|---|
| | 4173 | <para> |
|---|
| | 4174 | Fix <application>pg_ctl</application> to properly preserve postmaster |
|---|
| | 4175 | command-line arguments across a <literal>restart</literal> (Bruce) |
|---|
| | 4176 | </para> |
|---|
| | 4177 | </listitem> |
|---|
| | 4178 | |
|---|
| | 4179 | <listitem> |
|---|
| | 4180 | <para> |
|---|
| | 4181 | Update time zone data files to <application>tzdata</application> release 2008f (for |
|---|
| | 4182 | DST law changes in Argentina, Bahamas, Brazil, Mauritius, Morocco, |
|---|
| | 4183 | Pakistan, Palestine, and Paraguay) |
|---|
| | 4184 | </para> |
|---|
| | 4185 | </listitem> |
|---|
| | 4186 | |
|---|
| | 4187 | </itemizedlist> |
|---|
| | 4188 | |
|---|
| | 4189 | </sect2> |
|---|
| | 4190 | </sect1> |
|---|
| | 8434 | |
|---|
| | 8435 | </sect2> |
|---|
| | 8436 | </sect1> |
|---|
| | 8437 | |
|---|
| | 8438 | <sect1 id="release-7-4-22"> |
|---|
| | 8439 | <title>Release 7.4.22</title> |
|---|
| | 8440 | |
|---|
| | 8441 | <note> |
|---|
| | 8442 | <title>Release date</title> |
|---|
| | 8443 | <simpara>2008-09-22</simpara> |
|---|
| | 8444 | </note> |
|---|
| | 8445 | |
|---|
| | 8446 | <para> |
|---|
| | 8447 | This release contains a variety of fixes from 7.4.21. |
|---|
| | 8448 | For information about new features in the 7.4 major release, see |
|---|
| | 8449 | <xref linkend="release-7-4"/>. |
|---|
| | 8450 | </para> |
|---|
| | 8451 | |
|---|
| | 8452 | <sect2> |
|---|
| | 8453 | <title>Migration to Version 7.4.22</title> |
|---|
| | 8454 | |
|---|
| | 8455 | <para> |
|---|
| | 8456 | A dump/restore is not required for those running 7.4.X. |
|---|
| | 8457 | However, if you are upgrading from a version earlier than 7.4.11, |
|---|
| | 8458 | see the release notes for 7.4.11. |
|---|
| | 8459 | </para> |
|---|
| | 8460 | |
|---|
| | 8461 | </sect2> |
|---|
| | 8462 | |
|---|
| | 8463 | <sect2> |
|---|
| | 8464 | <title>Changes</title> |
|---|
| | 8465 | |
|---|
| | 8466 | <itemizedlist> |
|---|
| | 8467 | |
|---|
| | 8468 | <listitem> |
|---|
| | 8469 | <para> |
|---|
| | 8470 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 8471 | running on a 64-bit platform (Tom) |
|---|
| | 8472 | </para> |
|---|
| | 8473 | </listitem> |
|---|
| | 8474 | |
|---|
| | 8475 | <listitem> |
|---|
| | 8476 | <para> |
|---|
| | 8477 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 8478 | </para> |
|---|
| | 8479 | </listitem> |
|---|
| | 8480 | |
|---|
| | 8481 | <listitem> |
|---|
| | 8482 | <para> |
|---|
| | 8483 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 8484 | ON</> query (Tom) |
|---|
| | 8485 | </para> |
|---|
| | 8486 | </listitem> |
|---|
| | 8487 | |
|---|
| | 8488 | <listitem> |
|---|
| | 8489 | <para> |
|---|
| | 8490 | Fix planner to estimate that <literal>GROUP BY</> expressions yielding |
|---|
| | 8491 | boolean results always result in two groups, regardless of the |
|---|
| | 8492 | expressions' contents (Tom) |
|---|
| | 8493 | </para> |
|---|
| | 8494 | |
|---|
| | 8495 | <para> |
|---|
| | 8496 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 8497 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 8498 | <literal>IS NULL</literal>. |
|---|
| | 8499 | </para> |
|---|
| | 8500 | </listitem> |
|---|
| | 8501 | |
|---|
| | 8502 | <listitem> |
|---|
| | 8503 | <para> |
|---|
| | 8504 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 8505 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 8506 | </para> |
|---|
| | 8507 | </listitem> |
|---|
| | 8508 | |
|---|
| | 8509 | </itemizedlist> |
|---|