From 4394fe3dcb105219fc10ff80e0b433659a540eff Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 19 Sep 2012 17:38:37 -0400 Subject: [PATCH] Update release notes for 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21. --- doc/src/sgml/release-8.3.sgml | 110 +++++++++++++++ doc/src/sgml/release-8.4.sgml | 116 ++++++++++++++++ doc/src/sgml/release-9.0.sgml | 142 +++++++++++++++++++ doc/src/sgml/release-9.1.sgml | 255 ++++++++++++++++++++++++++++++++++ doc/src/sgml/release-9.2.sgml | 171 +++++++++++++++++++++++ 5 files changed, 794 insertions(+) diff --git a/doc/src/sgml/release-8.3.sgml b/doc/src/sgml/release-8.3.sgml index dda418fa55..d3b163a4d3 100644 --- a/doc/src/sgml/release-8.3.sgml +++ b/doc/src/sgml/release-8.3.sgml @@ -1,6 +1,116 @@ + + Release 8.3.21 + + + Release Date + 2012-09-24 + + + + This release contains a variety of fixes from 8.3.20. + For information about new features in the 8.3 major release, see + . + + + + The PostgreSQL community will stop releasing updates + for the 8.3.X release series in February 2013. + Users are encouraged to update to a newer release branch soon. + + + + Migration to Version 8.3.21 + + + A dump/restore is not required for those running 8.3.X. + + + + However, if you are upgrading from a version earlier than 8.3.17, + see the release notes for 8.3.17. + + + + + + Changes + + + + + + Improve page-splitting decisions in GiST indexes (Alexander Korotkov, + Robert Haas, Tom Lane) + + + + Multi-column GiST indexes might suffer unexpected bloat due to this + error. + + + + + + Fix cascading privilege revoke to stop if privileges are still held + (Tom Lane) + + + + If we revoke a grant option from some role X, but + X still holds that option via a grant from someone + else, we should not recursively revoke the corresponding privilege + from role(s) Y that X had granted it + to. + + + + + + Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) + + + + Perl resets the process's SIGFPE handler to + SIG_IGN, which could result in crashes later on. Restore + the normal Postgres signal handler after initializing PL/Perl. + + + + + + Prevent PL/Perl from crashing if a recursive PL/Perl function is + redefined while being executed (Tom Lane) + + + + + + Work around possible misoptimization in PL/Perl (Tom Lane) + + + + Some Linux distributions contain an incorrect version of + pthread.h that results in incorrect compiled code in + PL/Perl, leading to crashes if a PL/Perl function calls another one + that throws an error. + + + + + + Update time zone data files to tzdata release 2012f + for DST law changes in Fiji + + + + + + + + Release 8.3.20 diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml index 5c89fb699a..54f5c131af 100644 --- a/doc/src/sgml/release-8.4.sgml +++ b/doc/src/sgml/release-8.4.sgml @@ -1,6 +1,122 @@ + + Release 8.4.14 + + + Release Date + 2012-09-24 + + + + This release contains a variety of fixes from 8.4.13. + For information about new features in the 8.4 major release, see + . + + + + Migration to Version 8.4.14 + + + A dump/restore is not required for those running 8.4.X. + + + + However, if you are upgrading from a version earlier than 8.4.10, + see the release notes for 8.4.10. + + + + + + Changes + + + + + + Fix planner's assignment of executor parameters, and fix executor's + rescan logic for CTE plan nodes (Tom Lane) + + + + These errors could result in wrong answers from queries that scan the + same WITH subquery multiple times. + + + + + + Improve page-splitting decisions in GiST indexes (Alexander Korotkov, + Robert Haas, Tom Lane) + + + + Multi-column GiST indexes might suffer unexpected bloat due to this + error. + + + + + + Fix cascading privilege revoke to stop if privileges are still held + (Tom Lane) + + + + If we revoke a grant option from some role X, but + X still holds that option via a grant from someone + else, we should not recursively revoke the corresponding privilege + from role(s) Y that X had granted it + to. + + + + + + Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) + + + + Perl resets the process's SIGFPE handler to + SIG_IGN, which could result in crashes later on. Restore + the normal Postgres signal handler after initializing PL/Perl. + + + + + + Prevent PL/Perl from crashing if a recursive PL/Perl function is + redefined while being executed (Tom Lane) + + + + + + Work around possible misoptimization in PL/Perl (Tom Lane) + + + + Some Linux distributions contain an incorrect version of + pthread.h that results in incorrect compiled code in + PL/Perl, leading to crashes if a PL/Perl function calls another one + that throws an error. + + + + + + Update time zone data files to tzdata release 2012f + for DST law changes in Fiji + + + + + + + + Release 8.4.13 diff --git a/doc/src/sgml/release-9.0.sgml b/doc/src/sgml/release-9.0.sgml index 398a365919..af99af82be 100644 --- a/doc/src/sgml/release-9.0.sgml +++ b/doc/src/sgml/release-9.0.sgml @@ -1,6 +1,148 @@ + + Release 9.0.10 + + + Release Date + 2012-09-24 + + + + This release contains a variety of fixes from 9.0.9. + For information about new features in the 9.0 major release, see + . + + + + Migration to Version 9.0.10 + + + A dump/restore is not required for those running 9.0.X. + + + + However, if you are upgrading from a version earlier than 9.0.6, + see the release notes for 9.0.6. + + + + + + Changes + + + + + + Fix planner's assignment of executor parameters, and fix executor's + rescan logic for CTE plan nodes (Tom Lane) + + + + These errors could result in wrong answers from queries that scan the + same WITH subquery multiple times. + + + + + + Improve page-splitting decisions in GiST indexes (Alexander Korotkov, + Robert Haas, Tom Lane) + + + + Multi-column GiST indexes might suffer unexpected bloat due to this + error. + + + + + + Fix cascading privilege revoke to stop if privileges are still held + (Tom Lane) + + + + If we revoke a grant option from some role X, but + X still holds that option via a grant from someone + else, we should not recursively revoke the corresponding privilege + from role(s) Y that X had granted it + to. + + + + + + Improve error messages for Hot Standby misconfiguration errors + (Gurjeet Singh) + + + + + + Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) + + + + Perl resets the process's SIGFPE handler to + SIG_IGN, which could result in crashes later on. Restore + the normal Postgres signal handler after initializing PL/Perl. + + + + + + Prevent PL/Perl from crashing if a recursive PL/Perl function is + redefined while being executed (Tom Lane) + + + + + + Work around possible misoptimization in PL/Perl (Tom Lane) + + + + Some Linux distributions contain an incorrect version of + pthread.h that results in incorrect compiled code in + PL/Perl, leading to crashes if a PL/Perl function calls another one + that throws an error. + + + + + + Fix pg_upgrade's handling of line endings on Windows + (Andrew Dunstan) + + + + Previously, pg_upgrade might add or remove carriage + returns in places such as function bodies. + + + + + + On Windows, make pg_upgrade use backslash path + separators in the scripts it emits (Andrew Dunstan) + + + + + + Update time zone data files to tzdata release 2012f + for DST law changes in Fiji + + + + + + + + Release 9.0.9 diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml index a65d7fb635..6bc1c8c90e 100644 --- a/doc/src/sgml/release-9.1.sgml +++ b/doc/src/sgml/release-9.1.sgml @@ -1,6 +1,261 @@ + + Release 9.1.6 + + + Release Date + 2012-09-24 + + + + This release contains a variety of fixes from 9.1.5. + For information about new features in the 9.1 major release, see + . + + + + Migration to Version 9.1.6 + + + A dump/restore is not required for those running 9.1.X. + + + + However, you may need to perform REINDEX operations to + recover from the effects of the data corruption bug described in the + first changelog item below. + + + + Also, if you are upgrading from a version earlier than 9.1.4, + see the release notes for 9.1.4. + + + + + + Changes + + + + + + Fix persistence marking of shared buffers during WAL replay + (Jeff Davis) + + + + This mistake can result in buffers not being written out during + checkpoints, resulting in data corruption if the server later crashes + without ever having written those buffers. Corruption can occur on + any server following crash recovery, but it is significantly more + likely to occur on standby slave servers since those perform much + more WAL replay. There is a low probability of corruption of btree + and GIN indexes. There is a much higher probability of corruption of + table visibility maps. Fortunately, visibility maps are + non-critical data in 9.1, so the worst consequence of such corruption + in 9.1 installations is transient inefficiency of vacuuming. Table + data proper cannot be corrupted by this bug. + + + + While no index corruption due to this bug is known to have occurred + in the field, as a precautionary measure it is recommended that + production installations REINDEX all btree and GIN + indexes at a convenient time after upgrading to 9.1.6. + + + + Also, if you intend to do an in-place upgrade to 9.2.X, before doing + so it is recommended to perform a VACUUM of all tables + while having vacuum_freeze_table_age + set to zero. This will ensure that any lingering wrong data in the + visibility maps is corrected before 9.2.X can depend on it. vacuum_cost_delay + can be adjusted to reduce the performance impact of vacuuming, while + causing it to take longer to finish. + + + + + + Fix planner's assignment of executor parameters, and fix executor's + rescan logic for CTE plan nodes (Tom Lane) + + + + These errors could result in wrong answers from queries that scan the + same WITH subquery multiple times. + + + + + + Fix misbehavior when default_transaction_isolation + is set to serializable (Kevin Grittner, Tom Lane, Heikki + Linnakangas) + + + + Symptoms include crashes at process start on Windows, and crashes in + hot standby operation. + + + + + + Improve selectivity estimation for text search queries involving + prefixes, i.e. word:* patterns (Tom Lane) + + + + + + + + + Improve page-splitting decisions in GiST indexes (Alexander Korotkov, + Robert Haas, Tom Lane) + + + + Multi-column GiST indexes might suffer unexpected bloat due to this + error. + + + + + + Fix cascading privilege revoke to stop if privileges are still held + (Tom Lane) + + + + If we revoke a grant option from some role X, but + X still holds that option via a grant from someone + else, we should not recursively revoke the corresponding privilege + from role(s) Y that X had granted it + to. + + + + + + Disallow extensions from containing the schema they are assigned to + (Thom Brown) + + + + This situation creates circular dependencies that confuse + pg_dump and probably other things. It's confusing + for humans too, so disallow it. + + + + + + Improve error messages for Hot Standby misconfiguration errors + (Gurjeet Singh) + + + + + + Make configure probe for mbstowcs_l (Tom + Lane) + + + + This fixes build failures on some versions of AIX. + + + + + + Fix handling of SIGFPE when PL/Perl is in use (Andres Freund) + + + + Perl resets the process's SIGFPE handler to + SIG_IGN, which could result in crashes later on. Restore + the normal Postgres signal handler after initializing PL/Perl. + + + + + + Prevent PL/Perl from crashing if a recursive PL/Perl function is + redefined while being executed (Tom Lane) + + + + + + Work around possible misoptimization in PL/Perl (Tom Lane) + + + + Some Linux distributions contain an incorrect version of + pthread.h that results in incorrect compiled code in + PL/Perl, leading to crashes if a PL/Perl function calls another one + that throws an error. + + + + + + Fix bugs in contrib/pg_trgm's LIKE pattern + analysis code (Fujii Masao) + + + + LIKE queries using a trigram index could produce wrong + results if the pattern contained LIKE escape characters. + + + + + + Fix pg_upgrade's handling of line endings on Windows + (Andrew Dunstan) + + + + Previously, pg_upgrade might add or remove carriage + returns in places such as function bodies. + + + + + + On Windows, make pg_upgrade use backslash path + separators in the scripts it emits (Andrew Dunstan) + + + + + + Remove unnecessary dependency on pg_config from + pg_upgrade (Peter Eisentraut) + + + + + + Update time zone data files to tzdata release 2012f + for DST law changes in Fiji + + + + + + + + Release 9.1.5 diff --git a/doc/src/sgml/release-9.2.sgml b/doc/src/sgml/release-9.2.sgml index 1f0d54a8da..840e7a7a0d 100644 --- a/doc/src/sgml/release-9.2.sgml +++ b/doc/src/sgml/release-9.2.sgml @@ -1,6 +1,177 @@ + + Release 9.2.1 + + + Release Date + 2012-09-24 + + + + This release contains a variety of fixes from 9.2.0. + For information about new features in the 9.2 major release, see + . + + + + Migration to Version 9.2.1 + + + A dump/restore is not required for those running 9.2.X. + + + + However, you may need to perform REINDEX and/or + VACUUM operations to recover from the effects of the data + corruption bug described in the first changelog item below. + + + + + + Changes + + + + + + Fix persistence marking of shared buffers during WAL replay + (Jeff Davis) + + + + This mistake can result in buffers not being written out during + checkpoints, resulting in data corruption if the server later crashes + without ever having written those buffers. Corruption can occur on + any server following crash recovery, but it is significantly more + likely to occur on standby slave servers since those perform much + more WAL replay. There is a low probability of corruption of btree + and GIN indexes. There is a much higher probability of corruption + of table visibility maps, which might lead to wrong answers + from index-only scans. Table data proper cannot be corrupted by this + bug. + + + + While no index corruption due to this bug is known to have occurred + in the field, as a precautionary measure it is recommended that + production installations REINDEX all btree and GIN + indexes at a convenient time after upgrading to 9.2.1. + + + + Also, it is recommended to perform a VACUUM of all tables + while having vacuum_freeze_table_age + set to zero. This will fix any incorrect visibility map data. vacuum_cost_delay + can be adjusted to reduce the performance impact of vacuuming, while + causing it to take longer to finish. + + + + + + Fix possible incorrect sorting of output from queries involving + WHERE indexed_column IN + (list_of_values) (Tom Lane) + + + + + + Fix planner failure for queries involving GROUP BY + expressions along with window functions and aggregates (Tom Lane) + + + + + + Fix planner's assignment of executor parameters (Tom Lane) + + + + This error could result in wrong answers from queries that scan the + same WITH subquery multiple times. + + + + + + Improve planner's handling of join conditions in index scans (Tom Lane) + + + + + + Improve selectivity estimation for text search queries involving + prefixes, i.e. word:* patterns (Tom Lane) + + + + + + + + + Fix delayed recognition of permissions changes (Tom Lane) + + + + A command that needed no locks other than ones its transaction already + had might fail to notice a concurrent GRANT or + REVOKE that committed since the start of its transaction. + + + + + + Fix ANALYZE to not fail when a column is a domain over an + array type (Tom Lane) + + + + + + Prevent PL/Perl from crashing if a recursive PL/Perl function is + redefined while being executed (Tom Lane) + + + + + + Work around possible misoptimization in PL/Perl (Tom Lane) + + + + Some Linux distributions contain an incorrect version of + pthread.h that results in incorrect compiled code in + PL/Perl, leading to crashes if a PL/Perl function calls another one + that throws an error. + + + + + + Remove unnecessary dependency on pg_config from + pg_upgrade (Peter Eisentraut) + + + + + + Update time zone data files to tzdata release 2012f + for DST law changes in Fiji + + + + + + + + Release 9.2 -- 2.40.0