| | 66 | |
|---|
| | 67 | <sect1 id="release-8-2-10"> |
|---|
| | 68 | <title>Release 8.2.10</title> |
|---|
| | 69 | |
|---|
| | 70 | <note> |
|---|
| | 71 | <title>Release date</title> |
|---|
| | 72 | <simpara>2008-09-22</simpara> |
|---|
| | 73 | </note> |
|---|
| | 74 | |
|---|
| | 75 | <para> |
|---|
| | 76 | This release contains a variety of fixes from 8.2.9. |
|---|
| | 77 | For information about new features in the 8.2 major release, see |
|---|
| | 78 | <xref linkend="release-8-2"/>. |
|---|
| | 79 | </para> |
|---|
| | 80 | |
|---|
| | 81 | <sect2> |
|---|
| | 82 | <title>Migration to Version 8.2.10</title> |
|---|
| | 83 | |
|---|
| | 84 | <para> |
|---|
| | 85 | A dump/restore is not required for those running 8.2.X. |
|---|
| | 86 | However, if you are upgrading from a version earlier than 8.2.7, |
|---|
| | 87 | see the release notes for 8.2.7. |
|---|
| | 88 | </para> |
|---|
| | 89 | |
|---|
| | 90 | </sect2> |
|---|
| | 91 | |
|---|
| | 92 | <sect2> |
|---|
| | 93 | <title>Changes</title> |
|---|
| | 94 | |
|---|
| | 95 | <itemizedlist> |
|---|
| | 96 | |
|---|
| | 97 | <listitem> |
|---|
| | 98 | <para> |
|---|
| | 99 | Fix bug in btree WAL recovery code (Heikki) |
|---|
| | 100 | </para> |
|---|
| | 101 | |
|---|
| | 102 | <para> |
|---|
| | 103 | Recovery failed if the WAL ended partway through a page split operation. |
|---|
| | 104 | </para> |
|---|
| | 105 | </listitem> |
|---|
| | 106 | |
|---|
| | 107 | <listitem> |
|---|
| | 108 | <para> |
|---|
| | 109 | Fix potential miscalculation of <structfield>datfrozenxid</structfield> (Alvaro) |
|---|
| | 110 | </para> |
|---|
| | 111 | |
|---|
| | 112 | <para> |
|---|
| | 113 | This error may explain some recent reports of failure to remove old |
|---|
| | 114 | <structname>pg_clog</structname> data. |
|---|
| | 115 | </para> |
|---|
| | 116 | </listitem> |
|---|
| | 117 | |
|---|
| | 118 | <listitem> |
|---|
| | 119 | <para> |
|---|
| | 120 | Widen local lock counters from 32 to 64 bits (Tom) |
|---|
| | 121 | </para> |
|---|
| | 122 | |
|---|
| | 123 | <para> |
|---|
| | 124 | This responds to reports that the counters could overflow in |
|---|
| | 125 | sufficiently long transactions, leading to unexpected <quote>lock is |
|---|
| | 126 | already held</quote> errors. |
|---|
| | 127 | </para> |
|---|
| | 128 | </listitem> |
|---|
| | 129 | |
|---|
| | 130 | <listitem> |
|---|
| | 131 | <para> |
|---|
| | 132 | Fix possible duplicate output of tuples during a GiST index scan (Teodor) |
|---|
| | 133 | </para> |
|---|
| | 134 | </listitem> |
|---|
| | 135 | |
|---|
| | 136 | <listitem> |
|---|
| | 137 | <para> |
|---|
| | 138 | Fix missed permissions checks when a view contains a simple |
|---|
| | 139 | <literal>UNION ALL</literal> construct (Heikki) |
|---|
| | 140 | </para> |
|---|
| | 141 | |
|---|
| | 142 | <para> |
|---|
| | 143 | Permissions for the referenced tables were checked properly, but not |
|---|
| | 144 | permissions for the view itself. |
|---|
| | 145 | </para> |
|---|
| | 146 | </listitem> |
|---|
| | 147 | |
|---|
| | 148 | <listitem> |
|---|
| | 149 | <para> |
|---|
| | 150 | Add checks in executor startup to ensure that the tuples produced by an |
|---|
| | 151 | <command>INSERT</command> or <command>UPDATE</command> will match the target table's |
|---|
| | 152 | current rowtype (Tom) |
|---|
| | 153 | </para> |
|---|
| | 154 | |
|---|
| | 155 | <para> |
|---|
| | 156 | <command>ALTER COLUMN TYPE</command>, followed by re-use of a previously |
|---|
| | 157 | cached plan, could produce this type of situation. The check protects |
|---|
| | 158 | against data corruption and/or crashes that could ensue. |
|---|
| | 159 | </para> |
|---|
| | 160 | </listitem> |
|---|
| | 161 | |
|---|
| | 162 | <listitem> |
|---|
| | 163 | <para> |
|---|
| | 164 | Fix possible repeated drops during <command>DROP OWNED</command> (Tom) |
|---|
| | 165 | </para> |
|---|
| | 166 | |
|---|
| | 167 | <para> |
|---|
| | 168 | This would typically result in strange errors such as <quote>cache |
|---|
| | 169 | lookup failed for relation NNN</quote>. |
|---|
| | 170 | </para> |
|---|
| | 171 | </listitem> |
|---|
| | 172 | |
|---|
| | 173 | <listitem> |
|---|
| | 174 | <para> |
|---|
| | 175 | Fix <literal>AT TIME ZONE</literal> to first try to interpret its timezone |
|---|
| | 176 | argument as a timezone abbreviation, and only try it as a full timezone |
|---|
| | 177 | name if that fails, rather than the other way around as formerly (Tom) |
|---|
| | 178 | </para> |
|---|
| | 179 | |
|---|
| | 180 | <para> |
|---|
| | 181 | The timestamp input functions have always resolved ambiguous zone names |
|---|
| | 182 | in this order. Making <literal>AT TIME ZONE</literal> do so as well improves |
|---|
| | 183 | consistency, and fixes a compatibility bug introduced in 8.1: |
|---|
| | 184 | in ambiguous cases we now behave the same as 8.0 and before did, |
|---|
| | 185 | since in the older versions <literal>AT TIME ZONE</literal> accepted |
|---|
| | 186 | <emphasis>only</emphasis> abbreviations. |
|---|
| | 187 | </para> |
|---|
| | 188 | </listitem> |
|---|
| | 189 | |
|---|
| | 190 | <listitem> |
|---|
| | 191 | <para> |
|---|
| | 192 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 193 | running on a 64-bit platform (Tom) |
|---|
| | 194 | </para> |
|---|
| | 195 | </listitem> |
|---|
| | 196 | |
|---|
| | 197 | <listitem> |
|---|
| | 198 | <para> |
|---|
| | 199 | Prevent integer overflows during units conversion when displaying a |
|---|
| | 200 | configuration parameter that has units (Tom) |
|---|
| | 201 | </para> |
|---|
| | 202 | </listitem> |
|---|
| | 203 | |
|---|
| | 204 | <listitem> |
|---|
| | 205 | <para> |
|---|
| | 206 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 207 | </para> |
|---|
| | 208 | </listitem> |
|---|
| | 209 | |
|---|
| | 210 | <listitem> |
|---|
| | 211 | <para> |
|---|
| | 212 | Allow spaces in the suffix part of an LDAP URL in |
|---|
| | 213 | <filename>pg_hba.conf</filename> (Tom) |
|---|
| | 214 | </para> |
|---|
| | 215 | </listitem> |
|---|
| | 216 | |
|---|
| | 217 | <listitem> |
|---|
| | 218 | <para> |
|---|
| | 219 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 220 | ON</literal> query (Tom) |
|---|
| | 221 | </para> |
|---|
| | 222 | </listitem> |
|---|
| | 223 | |
|---|
| | 224 | <listitem> |
|---|
| | 225 | <para> |
|---|
| | 226 | Fix planner bug with nested sub-select expressions (Tom) |
|---|
| | 227 | </para> |
|---|
| | 228 | |
|---|
| | 229 | <para> |
|---|
| | 230 | If the outer sub-select has no direct dependency on the parent query, |
|---|
| | 231 | but the inner one does, the outer value might not get recalculated |
|---|
| | 232 | for new parent query rows. |
|---|
| | 233 | </para> |
|---|
| | 234 | </listitem> |
|---|
| | 235 | |
|---|
| | 236 | <listitem> |
|---|
| | 237 | <para> |
|---|
| | 238 | Fix planner to estimate that <literal>GROUP BY</literal> expressions yielding |
|---|
| | 239 | boolean results always result in two groups, regardless of the |
|---|
| | 240 | expressions' contents (Tom) |
|---|
| | 241 | </para> |
|---|
| | 242 | |
|---|
| | 243 | <para> |
|---|
| | 244 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 245 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 246 | <literal>IS NULL</literal>. |
|---|
| | 247 | </para> |
|---|
| | 248 | </listitem> |
|---|
| | 249 | |
|---|
| | 250 | <listitem> |
|---|
| | 251 | <para> |
|---|
| | 252 | Fix PL/PgSQL to not fail when a <literal>FOR</literal> loop's target variable |
|---|
| | 253 | is a record containing composite-type fields (Tom) |
|---|
| | 254 | </para> |
|---|
| | 255 | </listitem> |
|---|
| | 256 | |
|---|
| | 257 | <listitem> |
|---|
| | 258 | <para> |
|---|
| | 259 | Fix PL/Tcl to behave correctly with Tcl 8.5, and to be more careful |
|---|
| | 260 | about the encoding of data sent to or from Tcl (Tom) |
|---|
| | 261 | </para> |
|---|
| | 262 | </listitem> |
|---|
| | 263 | |
|---|
| | 264 | <listitem> |
|---|
| | 265 | <para> |
|---|
| | 266 | On Windows, work around a Microsoft bug by preventing |
|---|
| | 267 | <application>libpq</application> from trying to send more than 64kB per system call |
|---|
| | 268 | (Magnus) |
|---|
| | 269 | </para> |
|---|
| | 270 | </listitem> |
|---|
| | 271 | |
|---|
| | 272 | <listitem> |
|---|
| | 273 | <para> |
|---|
| | 274 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 275 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 276 | </para> |
|---|
| | 277 | </listitem> |
|---|
| | 278 | |
|---|
| | 279 | <listitem> |
|---|
| | 280 | <para> |
|---|
| | 281 | Fix <application>pg_ctl</application> to properly preserve postmaster |
|---|
| | 282 | command-line arguments across a <literal>restart</literal> (Bruce) |
|---|
| | 283 | </para> |
|---|
| | 284 | </listitem> |
|---|
| | 285 | |
|---|
| | 286 | <listitem> |
|---|
| | 287 | <para> |
|---|
| | 288 | Update time zone data files to <application>tzdata</application> release 2008f (for |
|---|
| | 289 | DST law changes in Argentina, Bahamas, Brazil, Mauritius, Morocco, |
|---|
| | 290 | Pakistan, Palestine, and Paraguay) |
|---|
| | 291 | </para> |
|---|
| | 292 | </listitem> |
|---|
| | 293 | |
|---|
| | 294 | </itemizedlist> |
|---|
| | 295 | |
|---|
| | 296 | </sect2> |
|---|
| | 297 | </sect1> |
|---|
| | 4430 | <sect1 id="release-8-1-14"> |
|---|
| | 4431 | <title>Release 8.1.14</title> |
|---|
| | 4432 | |
|---|
| | 4433 | <note> |
|---|
| | 4434 | <title>Release date</title> |
|---|
| | 4435 | <simpara>2008-09-22</simpara> |
|---|
| | 4436 | </note> |
|---|
| | 4437 | |
|---|
| | 4438 | <para> |
|---|
| | 4439 | This release contains a variety of fixes from 8.1.13. |
|---|
| | 4440 | For information about new features in the 8.1 major release, see |
|---|
| | 4441 | <xref linkend="release-8-1"/>. |
|---|
| | 4442 | </para> |
|---|
| | 4443 | |
|---|
| | 4444 | <sect2> |
|---|
| | 4445 | <title>Migration to Version 8.1.14</title> |
|---|
| | 4446 | |
|---|
| | 4447 | <para> |
|---|
| | 4448 | A dump/restore is not required for those running 8.1.X. |
|---|
| | 4449 | However, if you are upgrading from a version earlier than 8.1.2, |
|---|
| | 4450 | see the release notes for 8.1.2. |
|---|
| | 4451 | </para> |
|---|
| | 4452 | |
|---|
| | 4453 | </sect2> |
|---|
| | 4454 | |
|---|
| | 4455 | <sect2> |
|---|
| | 4456 | <title>Changes</title> |
|---|
| | 4457 | |
|---|
| | 4458 | <itemizedlist> |
|---|
| | 4459 | |
|---|
| | 4460 | <listitem> |
|---|
| | 4461 | <para> |
|---|
| | 4462 | Widen local lock counters from 32 to 64 bits (Tom) |
|---|
| | 4463 | </para> |
|---|
| | 4464 | |
|---|
| | 4465 | <para> |
|---|
| | 4466 | This responds to reports that the counters could overflow in |
|---|
| | 4467 | sufficiently long transactions, leading to unexpected <quote>lock is |
|---|
| | 4468 | already held</quote> errors. |
|---|
| | 4469 | </para> |
|---|
| | 4470 | </listitem> |
|---|
| | 4471 | |
|---|
| | 4472 | <listitem> |
|---|
| | 4473 | <para> |
|---|
| | 4474 | Fix possible duplicate output of tuples during a GiST index scan (Teodor) |
|---|
| | 4475 | </para> |
|---|
| | 4476 | </listitem> |
|---|
| | 4477 | |
|---|
| | 4478 | <listitem> |
|---|
| | 4479 | <para> |
|---|
| | 4480 | Add checks in executor startup to ensure that the tuples produced by an |
|---|
| | 4481 | <command>INSERT</command> or <command>UPDATE</command> will match the target table's |
|---|
| | 4482 | current rowtype (Tom) |
|---|
| | 4483 | </para> |
|---|
| | 4484 | |
|---|
| | 4485 | <para> |
|---|
| | 4486 | <command>ALTER COLUMN TYPE</command>, followed by re-use of a previously |
|---|
| | 4487 | cached plan, could produce this type of situation. The check protects |
|---|
| | 4488 | against data corruption and/or crashes that could ensue. |
|---|
| | 4489 | </para> |
|---|
| | 4490 | </listitem> |
|---|
| | 4491 | |
|---|
| | 4492 | <listitem> |
|---|
| | 4493 | <para> |
|---|
| | 4494 | Fix <literal>AT TIME ZONE</literal> to first try to interpret its timezone |
|---|
| | 4495 | argument as a timezone abbreviation, and only try it as a full timezone |
|---|
| | 4496 | name if that fails, rather than the other way around as formerly (Tom) |
|---|
| | 4497 | </para> |
|---|
| | 4498 | |
|---|
| | 4499 | <para> |
|---|
| | 4500 | The timestamp input functions have always resolved ambiguous zone names |
|---|
| | 4501 | in this order. Making <literal>AT TIME ZONE</literal> do so as well improves |
|---|
| | 4502 | consistency, and fixes a compatibility bug introduced in 8.1: |
|---|
| | 4503 | in ambiguous cases we now behave the same as 8.0 and before did, |
|---|
| | 4504 | since in the older versions <literal>AT TIME ZONE</literal> accepted |
|---|
| | 4505 | <emphasis>only</emphasis> abbreviations. |
|---|
| | 4506 | </para> |
|---|
| | 4507 | </listitem> |
|---|
| | 4508 | |
|---|
| | 4509 | <listitem> |
|---|
| | 4510 | <para> |
|---|
| | 4511 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 4512 | running on a 64-bit platform (Tom) |
|---|
| | 4513 | </para> |
|---|
| | 4514 | </listitem> |
|---|
| | 4515 | |
|---|
| | 4516 | <listitem> |
|---|
| | 4517 | <para> |
|---|
| | 4518 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 4519 | </para> |
|---|
| | 4520 | </listitem> |
|---|
| | 4521 | |
|---|
| | 4522 | <listitem> |
|---|
| | 4523 | <para> |
|---|
| | 4524 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 4525 | ON</literal> query (Tom) |
|---|
| | 4526 | </para> |
|---|
| | 4527 | </listitem> |
|---|
| | 4528 | |
|---|
| | 4529 | <listitem> |
|---|
| | 4530 | <para> |
|---|
| | 4531 | Fix planner bug with nested sub-select expressions (Tom) |
|---|
| | 4532 | </para> |
|---|
| | 4533 | |
|---|
| | 4534 | <para> |
|---|
| | 4535 | If the outer sub-select has no direct dependency on the parent query, |
|---|
| | 4536 | but the inner one does, the outer value might not get recalculated |
|---|
| | 4537 | for new parent query rows. |
|---|
| | 4538 | </para> |
|---|
| | 4539 | </listitem> |
|---|
| | 4540 | |
|---|
| | 4541 | <listitem> |
|---|
| | 4542 | <para> |
|---|
| | 4543 | Fix planner to estimate that <literal>GROUP BY</literal> expressions yielding |
|---|
| | 4544 | boolean results always result in two groups, regardless of the |
|---|
| | 4545 | expressions' contents (Tom) |
|---|
| | 4546 | </para> |
|---|
| | 4547 | |
|---|
| | 4548 | <para> |
|---|
| | 4549 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 4550 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 4551 | <literal>IS NULL</literal>. |
|---|
| | 4552 | </para> |
|---|
| | 4553 | </listitem> |
|---|
| | 4554 | |
|---|
| | 4555 | <listitem> |
|---|
| | 4556 | <para> |
|---|
| | 4557 | Fix PL/PgSQL to not fail when a <literal>FOR</literal> loop's target variable |
|---|
| | 4558 | is a record containing composite-type fields (Tom) |
|---|
| | 4559 | </para> |
|---|
| | 4560 | </listitem> |
|---|
| | 4561 | |
|---|
| | 4562 | <listitem> |
|---|
| | 4563 | <para> |
|---|
| | 4564 | Fix PL/Tcl to behave correctly with Tcl 8.5, and to be more careful |
|---|
| | 4565 | about the encoding of data sent to or from Tcl (Tom) |
|---|
| | 4566 | </para> |
|---|
| | 4567 | </listitem> |
|---|
| | 4568 | |
|---|
| | 4569 | <listitem> |
|---|
| | 4570 | <para> |
|---|
| | 4571 | Fix PL/Python to work with Python 2.5 |
|---|
| | 4572 | </para> |
|---|
| | 4573 | |
|---|
| | 4574 | <para> |
|---|
| | 4575 | This is a back-port of fixes made during the 8.2 development cycle. |
|---|
| | 4576 | </para> |
|---|
| | 4577 | </listitem> |
|---|
| | 4578 | |
|---|
| | 4579 | <listitem> |
|---|
| | 4580 | <para> |
|---|
| | 4581 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 4582 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 4583 | </para> |
|---|
| | 4584 | </listitem> |
|---|
| | 4585 | |
|---|
| | 4586 | <listitem> |
|---|
| | 4587 | <para> |
|---|
| | 4588 | Fix <application>pg_ctl</application> to properly preserve postmaster |
|---|
| | 4589 | command-line arguments across a <literal>restart</literal> (Bruce) |
|---|
| | 4590 | </para> |
|---|
| | 4591 | </listitem> |
|---|
| | 4592 | |
|---|
| | 4593 | <listitem> |
|---|
| | 4594 | <para> |
|---|
| | 4595 | Update time zone data files to <application>tzdata</application> release 2008f (for |
|---|
| | 4596 | DST law changes in Argentina, Bahamas, Brazil, Mauritius, Morocco, |
|---|
| | 4597 | Pakistan, Palestine, and Paraguay) |
|---|
| | 4598 | </para> |
|---|
| | 4599 | </listitem> |
|---|
| | 4600 | |
|---|
| | 4601 | </itemizedlist> |
|---|
| | 4602 | |
|---|
| | 4603 | </sect2> |
|---|
| | 4604 | </sect1> |
|---|
| | 4605 | |
|---|
| | 8474 | |
|---|
| | 8475 | <sect1 id="release-8-0-18"> |
|---|
| | 8476 | <title>Release 8.0.18</title> |
|---|
| | 8477 | |
|---|
| | 8478 | <note> |
|---|
| | 8479 | <title>Release date</title> |
|---|
| | 8480 | <simpara>2008-09-22</simpara> |
|---|
| | 8481 | </note> |
|---|
| | 8482 | |
|---|
| | 8483 | <para> |
|---|
| | 8484 | This release contains a variety of fixes from 8.0.17. |
|---|
| | 8485 | For information about new features in the 8.0 major release, see |
|---|
| | 8486 | <xref linkend="release-8-0"/>. |
|---|
| | 8487 | </para> |
|---|
| | 8488 | |
|---|
| | 8489 | <sect2> |
|---|
| | 8490 | <title>Migration to Version 8.0.18</title> |
|---|
| | 8491 | |
|---|
| | 8492 | <para> |
|---|
| | 8493 | A dump/restore is not required for those running 8.0.X. |
|---|
| | 8494 | However, if you are upgrading from a version earlier than 8.0.6, |
|---|
| | 8495 | see the release notes for 8.0.6. |
|---|
| | 8496 | </para> |
|---|
| | 8497 | |
|---|
| | 8498 | </sect2> |
|---|
| | 8499 | |
|---|
| | 8500 | <sect2> |
|---|
| | 8501 | <title>Changes</title> |
|---|
| | 8502 | |
|---|
| | 8503 | <itemizedlist> |
|---|
| | 8504 | |
|---|
| | 8505 | <listitem> |
|---|
| | 8506 | <para> |
|---|
| | 8507 | Widen local lock counters from 32 to 64 bits (Tom) |
|---|
| | 8508 | </para> |
|---|
| | 8509 | |
|---|
| | 8510 | <para> |
|---|
| | 8511 | This responds to reports that the counters could overflow in |
|---|
| | 8512 | sufficiently long transactions, leading to unexpected <quote>lock is |
|---|
| | 8513 | already held</quote> errors. |
|---|
| | 8514 | </para> |
|---|
| | 8515 | </listitem> |
|---|
| | 8516 | |
|---|
| | 8517 | <listitem> |
|---|
| | 8518 | <para> |
|---|
| | 8519 | Add checks in executor startup to ensure that the tuples produced by an |
|---|
| | 8520 | <command>INSERT</command> or <command>UPDATE</command> will match the target table's |
|---|
| | 8521 | current rowtype (Tom) |
|---|
| | 8522 | </para> |
|---|
| | 8523 | |
|---|
| | 8524 | <para> |
|---|
| | 8525 | <command>ALTER COLUMN TYPE</command>, followed by re-use of a previously |
|---|
| | 8526 | cached plan, could produce this type of situation. The check protects |
|---|
| | 8527 | against data corruption and/or crashes that could ensue. |
|---|
| | 8528 | </para> |
|---|
| | 8529 | </listitem> |
|---|
| | 8530 | |
|---|
| | 8531 | <listitem> |
|---|
| | 8532 | <para> |
|---|
| | 8533 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 8534 | running on a 64-bit platform (Tom) |
|---|
| | 8535 | </para> |
|---|
| | 8536 | </listitem> |
|---|
| | 8537 | |
|---|
| | 8538 | <listitem> |
|---|
| | 8539 | <para> |
|---|
| | 8540 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 8541 | </para> |
|---|
| | 8542 | </listitem> |
|---|
| | 8543 | |
|---|
| | 8544 | <listitem> |
|---|
| | 8545 | <para> |
|---|
| | 8546 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 8547 | ON</literal> query (Tom) |
|---|
| | 8548 | </para> |
|---|
| | 8549 | </listitem> |
|---|
| | 8550 | |
|---|
| | 8551 | <listitem> |
|---|
| | 8552 | <para> |
|---|
| | 8553 | Fix planner to estimate that <literal>GROUP BY</literal> expressions yielding |
|---|
| | 8554 | boolean results always result in two groups, regardless of the |
|---|
| | 8555 | expressions' contents (Tom) |
|---|
| | 8556 | </para> |
|---|
| | 8557 | |
|---|
| | 8558 | <para> |
|---|
| | 8559 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 8560 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 8561 | <literal>IS NULL</literal>. |
|---|
| | 8562 | </para> |
|---|
| | 8563 | </listitem> |
|---|
| | 8564 | |
|---|
| | 8565 | <listitem> |
|---|
| | 8566 | <para> |
|---|
| | 8567 | Fix PL/Tcl to behave correctly with Tcl 8.5, and to be more careful |
|---|
| | 8568 | about the encoding of data sent to or from Tcl (Tom) |
|---|
| | 8569 | </para> |
|---|
| | 8570 | </listitem> |
|---|
| | 8571 | |
|---|
| | 8572 | <listitem> |
|---|
| | 8573 | <para> |
|---|
| | 8574 | Fix PL/Python to work with Python 2.5 |
|---|
| | 8575 | </para> |
|---|
| | 8576 | |
|---|
| | 8577 | <para> |
|---|
| | 8578 | This is a back-port of fixes made during the 8.2 development cycle. |
|---|
| | 8579 | </para> |
|---|
| | 8580 | </listitem> |
|---|
| | 8581 | |
|---|
| | 8582 | <listitem> |
|---|
| | 8583 | <para> |
|---|
| | 8584 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 8585 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 8586 | </para> |
|---|
| | 8587 | </listitem> |
|---|
| | 8588 | |
|---|
| | 8589 | <listitem> |
|---|
| | 8590 | <para> |
|---|
| | 8591 | Fix <application>pg_ctl</application> to properly preserve postmaster |
|---|
| | 8592 | command-line arguments across a <literal>restart</literal> (Bruce) |
|---|
| | 8593 | </para> |
|---|
| | 8594 | </listitem> |
|---|
| | 8595 | |
|---|
| | 8596 | <listitem> |
|---|
| | 8597 | <para> |
|---|
| | 8598 | Update time zone data files to <application>tzdata</application> release 2008f (for |
|---|
| | 8599 | DST law changes in Argentina, Bahamas, Brazil, Mauritius, Morocco, |
|---|
| | 8600 | Pakistan, Palestine, and Paraguay) |
|---|
| | 8601 | </para> |
|---|
| | 8602 | </listitem> |
|---|
| | 8603 | |
|---|
| | 8604 | </itemizedlist> |
|---|
| | 8605 | |
|---|
| | 8606 | </sect2> |
|---|
| | 8607 | </sect1> |
|---|
| | 12821 | |
|---|
| | 12822 | </sect2> |
|---|
| | 12823 | </sect1> |
|---|
| | 12824 | |
|---|
| | 12825 | <sect1 id="release-7-4-22"> |
|---|
| | 12826 | <title>Release 7.4.22</title> |
|---|
| | 12827 | |
|---|
| | 12828 | <note> |
|---|
| | 12829 | <title>Release date</title> |
|---|
| | 12830 | <simpara>2008-09-22</simpara> |
|---|
| | 12831 | </note> |
|---|
| | 12832 | |
|---|
| | 12833 | <para> |
|---|
| | 12834 | This release contains a variety of fixes from 7.4.21. |
|---|
| | 12835 | For information about new features in the 7.4 major release, see |
|---|
| | 12836 | <xref linkend="release-7-4"/>. |
|---|
| | 12837 | </para> |
|---|
| | 12838 | |
|---|
| | 12839 | <sect2> |
|---|
| | 12840 | <title>Migration to Version 7.4.22</title> |
|---|
| | 12841 | |
|---|
| | 12842 | <para> |
|---|
| | 12843 | A dump/restore is not required for those running 7.4.X. |
|---|
| | 12844 | However, if you are upgrading from a version earlier than 7.4.11, |
|---|
| | 12845 | see the release notes for 7.4.11. |
|---|
| | 12846 | </para> |
|---|
| | 12847 | |
|---|
| | 12848 | </sect2> |
|---|
| | 12849 | |
|---|
| | 12850 | <sect2> |
|---|
| | 12851 | <title>Changes</title> |
|---|
| | 12852 | |
|---|
| | 12853 | <itemizedlist> |
|---|
| | 12854 | |
|---|
| | 12855 | <listitem> |
|---|
| | 12856 | <para> |
|---|
| | 12857 | Fix datetime input functions to correctly detect integer overflow when |
|---|
| | 12858 | running on a 64-bit platform (Tom) |
|---|
| | 12859 | </para> |
|---|
| | 12860 | </listitem> |
|---|
| | 12861 | |
|---|
| | 12862 | <listitem> |
|---|
| | 12863 | <para> |
|---|
| | 12864 | Improve performance of writing very long log messages to syslog (Tom) |
|---|
| | 12865 | </para> |
|---|
| | 12866 | </listitem> |
|---|
| | 12867 | |
|---|
| | 12868 | <listitem> |
|---|
| | 12869 | <para> |
|---|
| | 12870 | Fix bug in backwards scanning of a cursor on a <literal>SELECT DISTINCT |
|---|
| | 12871 | ON</> query (Tom) |
|---|
| | 12872 | </para> |
|---|
| | 12873 | </listitem> |
|---|
| | 12874 | |
|---|
| | 12875 | <listitem> |
|---|
| | 12876 | <para> |
|---|
| | 12877 | Fix planner to estimate that <literal>GROUP BY</> expressions yielding |
|---|
| | 12878 | boolean results always result in two groups, regardless of the |
|---|
| | 12879 | expressions' contents (Tom) |
|---|
| | 12880 | </para> |
|---|
| | 12881 | |
|---|
| | 12882 | <para> |
|---|
| | 12883 | This is very substantially more accurate than the regular <literal>GROUP |
|---|
| | 12884 | BY</literal> estimate for certain boolean tests like <replaceable>col</replaceable> |
|---|
| | 12885 | <literal>IS NULL</literal>. |
|---|
| | 12886 | </para> |
|---|
| | 12887 | </listitem> |
|---|
| | 12888 | |
|---|
| | 12889 | <listitem> |
|---|
| | 12890 | <para> |
|---|
| | 12891 | Improve <application>pg_dump</application> and <application>pg_restore</application>'s |
|---|
| | 12892 | error reporting after failure to send a SQL command (Tom) |
|---|
| | 12893 | </para> |
|---|
| | 12894 | </listitem> |
|---|
| | 12895 | |
|---|
| | 12896 | </itemizedlist> |
|---|