From 67f898bd36f1dff19ab6fc741371f0a441b1ed72 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 2 Dec 2013 15:54:11 -0500 Subject: [PATCH] Update release notes for 9.3.2, 9.2.6, 9.1.11, 9.0.15, 8.4.19. --- doc/src/sgml/release-8.4.sgml | 242 +++++++++++++++++++++++++++++++--- 1 file changed, 225 insertions(+), 17 deletions(-) diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml index 45972c2395..5762e01f62 100644 --- a/doc/src/sgml/release-8.4.sgml +++ b/doc/src/sgml/release-8.4.sgml @@ -1,6 +1,207 @@ + + Release 8.4.19 + + + Release Date + 2013-12-05 + + + + This release contains a variety of fixes from 8.4.18. + For information about new features in the 8.4 major release, see + . + + + + Migration to Version 8.4.19 + + + A dump/restore is not required for those running 8.4.X. + + + + However, this release corrects a potential data corruption + issue. See the first changelog entry below to find out whether + your installation has been affected and what steps you can take if so. + + + + Also, if you are upgrading from a version earlier than 8.4.17, + see the release notes for 8.4.17. + + + + + + Changes + + + + + + Fix VACUUM's tests to see whether it can + update relfrozenxid (Andres Freund) + + + + In some cases VACUUM (either manual or autovacuum) could + incorrectly advance a table's relfrozenxid value, + allowing tuples to escape freezing, causing those rows to become + invisible once 2^31 transactions have elapsed. The probability of + data loss is fairly low since multiple incorrect advancements would + need to happen before actual loss occurs, but it's not zero. Users + upgrading from release 8.4.8 or earlier are not affected, but all later + versions contain the bug. + + + + The issue can be ameliorated by, after upgrading, vacuuming all tables + in all databases while having vacuum_freeze_table_age + set to zero. This will fix any latent corruption but will not be able + to fix all pre-existing data errors. However, an installation can be + presumed safe after performing this vacuuming if it has executed fewer + than 2^31 update transactions in its lifetime (check this with + SELECT txid_current() < 2^31). + + + + + + Fix race condition in GIN index posting tree page deletion (Heikki + Linnakangas) + + + + This could lead to transient wrong answers or query failures. + + + + + + Avoid flattening a subquery whose SELECT list contains a + volatile function wrapped inside a sub-SELECT (Tom Lane) + + + + This avoids unexpected results due to extra evaluations of the + volatile function. + + + + + + Fix planner's processing of non-simple-variable subquery outputs + nested within outer joins (Tom Lane) + + + + This error could lead to incorrect plans for queries involving + multiple levels of subqueries within JOIN syntax. + + + + + + Fix premature deletion of temporary files (Andres Freund) + + + + + + Fix possible read past end of memory in rule printing (Peter Eisentraut) + + + + + + Fix array slicing of int2vector and oidvector values + (Tom Lane) + + + + Expressions of this kind are now implicitly promoted to + regular int2 or oid arrays. + + + + + + Fix incorrect behaviors when using a SQL-standard, simple GMT offset + timezone (Tom Lane) + + + + In some cases, the system would use the simple GMT offset value when + it should have used the regular timezone setting that had prevailed + before the simple offset was selected. This change also causes + the timeofday function to honor the simple GMT offset + zone. + + + + + + Prevent possible misbehavior when logging translations of Windows + error codes (Tom Lane) + + + + + + Properly quote generated command lines in pg_ctl + (Naoya Anzai and Tom Lane) + + + + This fix applies only to Windows. + + + + + + Fix pg_dumpall to work when a source database + sets default_transaction_read_only + via ALTER DATABASE SET (Kevin Grittner) + + + + Previously, the generated script would fail during restore. + + + + + + Fix ecpg's processing of lists of variables + declared varchar (Zoltán Böszörményi) + + + + + + Make contrib/lo defend against incorrect trigger definitions + (Marc Cousin) + + + + + + Update time zone data files to tzdata release 2013h + for DST law changes in Argentina, Brazil, Jordan, Libya, + Liechtenstein, Morocco, and Palestine. Also, new timezone + abbreviations WIB, WIT, WITA for Indonesia. + + + + + + + + Release 8.4.18 @@ -23,8 +224,8 @@ - Also, if you are upgrading from a version earlier than 8.4.10, - see the release notes for 8.4.10. + However, if you are upgrading from a version earlier than 8.4.17, + see the release notes for 8.4.17. @@ -36,12 +237,13 @@ - Prevent downcasing of non-ASCII non-double-quoted identifiers in - multi-byte encodings (Andrew Dunstan) + Prevent corruption of multi-byte characters when attempting to + case-fold identifiers (Andrew Dunstan) - The previous behavior was wrong and confusing. + PostgreSQL case-folds non-ASCII characters only + when using a single-byte server encoding. @@ -61,7 +263,7 @@ - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) @@ -85,21 +287,24 @@ - Previously such push downs could generate errors. + Subqueries of a UNION or INTERSECT that + contain set-returning functions or volatile functions in their + SELECT lists could be improperly optimized, leading to + run-time errors or incorrect query results. - Fix rare GROUP BY query error caused by improperly - processed data type modifiers (Tom Lane) + Fix rare case of failed to locate grouping columns + planner failure (Tom Lane) - Allow view dump code to better handle dropped columns on base tables - (Tom Lane) + Improve view dumping code's handling of dropped columns in referenced + tables (Tom Lane) @@ -164,12 +369,16 @@ - Allow various spellings of infinity on all platforms (Tom Lane) + Ensure that floating-point data input accepts standard spellings + of infinity on all platforms (Tom Lane) - Supported infinity values are "inf", "+inf", "-inf", "infinity", - "+infinity", and "-infinity". + The C99 standard says that allowable spellings are inf, + +inf, -inf, infinity, + +infinity, and -infinity. Make sure we + recognize these even if the platform's strtod function + doesn't. @@ -183,9 +392,8 @@ Update time zone data files to tzdata release 2013d - for DST law changes in DST law changes in Israel, Morocco, Palestine, - Paraguay. Also, historical zone data corrections for Macquarie Island - (Tom Lane) + for DST law changes in Israel, Morocco, Palestine, and Paraguay. + Also, historical zone data corrections for Macquarie Island. -- 2.50.0