diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2013-11-30 16:57:12 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2013-11-30 16:57:25 -0500 |
commit | 47960354024eac823981d7f264a0cf804b0c42c9 (patch) | |
tree | 7dbf123775a9f0cd21fb5158a9e06e0e24fbd256 | |
parent | e7d56aee2d1805cd9d280c0e6f8c8af80a13aa3e (diff) | |
download | postgresql-47960354024eac823981d7f264a0cf804b0c42c9.tar.gz |
Editorial corrections to the October 2013 minor-release notes.
This is mostly to fix incorrect migration instructions: since the preceding
minor releases advised reindexing some GIST indexes, it's important that
we back-link to that advice rather than earlier instances.
Also improve some bug descriptions and fix a few typos.
No back-patch yet; these files will get copied into the back branches
later in the release process.
-rw-r--r-- | doc/src/sgml/release-8.4.sgml | 41 | ||||
-rw-r--r-- | doc/src/sgml/release-9.0.sgml | 53 | ||||
-rw-r--r-- | doc/src/sgml/release-9.1.sgml | 55 | ||||
-rw-r--r-- | doc/src/sgml/release-9.2.sgml | 66 | ||||
-rw-r--r-- | doc/src/sgml/release-9.3.sgml | 27 |
5 files changed, 147 insertions, 95 deletions
diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml index 45972c2395..0bff9e6ebc 100644 --- a/doc/src/sgml/release-8.4.sgml +++ b/doc/src/sgml/release-8.4.sgml @@ -23,8 +23,8 @@ </para> <para> - 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. </para> </sect2> @@ -36,12 +36,13 @@ <listitem> <para> - 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) </para> <para> - The previous behavior was wrong and confusing. + <productname>PostgreSQL</> case-folds non-ASCII characters only + when using a single-byte server encoding. </para> </listitem> @@ -61,7 +62,7 @@ <listitem> <para> - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) </para> </listitem> @@ -85,21 +86,24 @@ </para> <para> - Previously such push downs could generate errors. + Subqueries of a <literal>UNION</> or <literal>INTERSECT</> that + contain set-returning functions or volatile functions in their + <literal>SELECT</> lists could be improperly optimized, leading to + run-time errors or incorrect query results. </para> </listitem> <listitem> <para> - Fix rare <literal>GROUP BY</> query error caused by improperly - processed data type modifiers (Tom Lane) + Fix rare case of <quote>failed to locate grouping columns</> + planner failure (Tom Lane) </para> </listitem> <listitem> <para> - 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) </para> </listitem> @@ -164,12 +168,16 @@ <listitem> <para> - Allow various spellings of infinity on all platforms (Tom Lane) + Ensure that floating-point data input accepts standard spellings + of <quote>infinity</> on all platforms (Tom Lane) </para> <para> - Supported infinity values are "inf", "+inf", "-inf", "infinity", - "+infinity", and "-infinity". + The C99 standard says that allowable spellings are <literal>inf</>, + <literal>+inf</>, <literal>-inf</>, <literal>infinity</>, + <literal>+infinity</>, and <literal>-infinity</>. Make sure we + recognize these even if the platform's <function>strtod</> function + doesn't. </para> </listitem> @@ -183,9 +191,8 @@ <listitem> <para> Update time zone data files to <application>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. </para> </listitem> diff --git a/doc/src/sgml/release-9.0.sgml b/doc/src/sgml/release-9.0.sgml index fdd6baafb5..ca1d7d8c70 100644 --- a/doc/src/sgml/release-9.0.sgml +++ b/doc/src/sgml/release-9.0.sgml @@ -23,8 +23,8 @@ </para> <para> - Also, if you are upgrading from a version earlier than 9.0.6, - see the release notes for 9.0.6. + However, if you are upgrading from a version earlier than 9.0.13, + see the release notes for 9.0.13. </para> </sect2> @@ -36,12 +36,13 @@ <listitem> <para> - 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) </para> <para> - The previous behavior was wrong and confusing. + <productname>PostgreSQL</> case-folds non-ASCII characters only + when using a single-byte server encoding. </para> </listitem> @@ -68,13 +69,13 @@ <listitem> <para> - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) </para> </listitem> <listitem> <para> - Fix possible SSL network stack corruption in threaded libpq applications + Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost) </para> </listitem> @@ -99,21 +100,24 @@ </para> <para> - Previously such push downs could generate errors. + Subqueries of a <literal>UNION</> or <literal>INTERSECT</> that + contain set-returning functions or volatile functions in their + <literal>SELECT</> lists could be improperly optimized, leading to + run-time errors or incorrect query results. </para> </listitem> <listitem> <para> - Fix rare <literal>GROUP BY</> query error caused by improperly - processed data type modifiers (Tom Lane) + Fix rare case of <quote>failed to locate grouping columns</> + planner failure (Tom Lane) </para> </listitem> <listitem> <para> - 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) </para> </listitem> @@ -193,8 +197,9 @@ <para> Specifically, lessen keyword restrictions for role names, language names, <command>EXPLAIN</> and <command>COPY</> options, and - <command>SET</> values. This allows <literal>COPY ... (FORMAT - BINARY)</> previously <literal>BINARY</> required single-quotes. + <command>SET</> values. This allows <literal>COPY ... (FORMAT + BINARY)</> to work as expected; previously <literal>BINARY</> needed + to be quoted. </para> </listitem> @@ -214,8 +219,9 @@ <listitem> <para> - Improve analyze statistics generation after a cancelled file truncate - request (Kevin Grittner) + Ensure that <command>VACUUM ANALYZE</> still runs the ANALYZE phase + if its attempt to truncate the file is cancelled due to lock conflicts + (Kevin Grittner) </para> </listitem> @@ -228,12 +234,16 @@ <listitem> <para> - Allow various spellings of infinity on all platforms (Tom Lane) + Ensure that floating-point data input accepts standard spellings + of <quote>infinity</> on all platforms (Tom Lane) </para> <para> - Supported infinity values are "inf", "+inf", "-inf", "infinity", - "+infinity", and "-infinity". + The C99 standard says that allowable spellings are <literal>inf</>, + <literal>+inf</>, <literal>-inf</>, <literal>infinity</>, + <literal>+infinity</>, and <literal>-infinity</>. Make sure we + recognize these even if the platform's <function>strtod</> function + doesn't. </para> </listitem> @@ -247,9 +257,8 @@ <listitem> <para> Update time zone data files to <application>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. </para> </listitem> diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml index 20eff0b292..577b9b852e 100644 --- a/doc/src/sgml/release-9.1.sgml +++ b/doc/src/sgml/release-9.1.sgml @@ -23,8 +23,8 @@ </para> <para> - Also, if you are upgrading from a version earlier than 9.1.6, - see the release notes for 9.1.6. + However, if you are upgrading from a version earlier than 9.1.9, + see the release notes for 9.1.9. </para> </sect2> @@ -36,12 +36,13 @@ <listitem> <para> - 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) </para> <para> - The previous behavior was wrong and confusing. + <productname>PostgreSQL</> case-folds non-ASCII characters only + when using a single-byte server encoding. </para> </listitem> @@ -74,13 +75,13 @@ <listitem> <para> - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) </para> </listitem> <listitem> <para> - Fix possible SSL network stack corruption in threaded libpq applications + Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost) </para> </listitem> @@ -105,14 +106,17 @@ </para> <para> - Previously such push downs could generate errors. + Subqueries of a <literal>UNION</> or <literal>INTERSECT</> that + contain set-returning functions or volatile functions in their + <literal>SELECT</> lists could be improperly optimized, leading to + run-time errors or incorrect query results. </para> </listitem> <listitem> <para> - Fix rare <literal>GROUP BY</> query error caused by improperly - processed data type modifiers (Tom Lane) + Fix rare case of <quote>failed to locate grouping columns</> + planner failure (Tom Lane) </para> </listitem> @@ -142,8 +146,8 @@ <listitem> <para> - 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) </para> </listitem> @@ -254,8 +258,9 @@ <para> Specifically, lessen keyword restrictions for role names, language names, <command>EXPLAIN</> and <command>COPY</> options, and - <command>SET</> values. This allows <literal>COPY ... (FORMAT - BINARY)</> previously <literal>BINARY</> required single-quotes. + <command>SET</> values. This allows <literal>COPY ... (FORMAT + BINARY)</> to work as expected; previously <literal>BINARY</> needed + to be quoted. </para> </listitem> @@ -268,7 +273,7 @@ <listitem> <para> - Have <application>pg_upgrade</> use <command>pg_dump + Make <application>pg_upgrade</> use <literal>pg_dump --quote-all-identifiers</> to avoid problems with keyword changes between releases (Tom Lane) </para> @@ -283,8 +288,9 @@ <listitem> <para> - Improve analyze statistics generation after a cancelled file truncate - request (Kevin Grittner) + Ensure that <command>VACUUM ANALYZE</> still runs the ANALYZE phase + if its attempt to truncate the file is cancelled due to lock conflicts + (Kevin Grittner) </para> </listitem> @@ -297,12 +303,16 @@ <listitem> <para> - Allow various spellings of infinity on all platforms (Tom Lane) + Ensure that floating-point data input accepts standard spellings + of <quote>infinity</> on all platforms (Tom Lane) </para> <para> - Supported infinity values are "inf", "+inf", "-inf", "infinity", - "+infinity", and "-infinity". + The C99 standard says that allowable spellings are <literal>inf</>, + <literal>+inf</>, <literal>-inf</>, <literal>infinity</>, + <literal>+infinity</>, and <literal>-infinity</>. Make sure we + recognize these even if the platform's <function>strtod</> function + doesn't. </para> </listitem> @@ -316,9 +326,8 @@ <listitem> <para> Update time zone data files to <application>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. </para> </listitem> diff --git a/doc/src/sgml/release-9.2.sgml b/doc/src/sgml/release-9.2.sgml index 07968f0d38..034e580ded 100644 --- a/doc/src/sgml/release-9.2.sgml +++ b/doc/src/sgml/release-9.2.sgml @@ -23,8 +23,8 @@ </para> <para> - Also, if you are upgrading from a version earlier than 9.2.2, - see the release notes for 9.2.2. + However, if you are upgrading from a version earlier than 9.2.4, + see the release notes for 9.2.4. </para> </sect2> @@ -36,18 +36,20 @@ <listitem> <para> - 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) </para> <para> - The previous behavior was wrong and confusing. + <productname>PostgreSQL</> case-folds non-ASCII characters only + when using a single-byte server encoding. </para> </listitem> <listitem> <para> - Fix memory leak when creating range indexes (Heikki Linnakangas) + Fix memory leak when creating B-tree indexes on range columns + (Heikki Linnakangas) </para> </listitem> @@ -80,13 +82,13 @@ <listitem> <para> - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) </para> </listitem> <listitem> <para> - Fix possible SSL network stack corruption in threaded libpq applications + Fix possible SSL state corruption in threaded libpq applications (Nick Phillips, Stephen Frost) </para> </listitem> @@ -117,13 +119,13 @@ <listitem> <para> - Fix <literal>UNION ALL</> and inheritance queries to properly - recheck parameterized paths (Tom Lane) + Fix accounting for qualifier evaluation costs in <literal>UNION ALL</> + and inheritance queries (Tom Lane) </para> <para> - This fixes cases where suboptimal query plans could potentially be - chosen. + This fixes cases where suboptimal query plans could be chosen if + some <literal>WHERE</> clauses are expensive to calculate. </para> </listitem> @@ -134,14 +136,17 @@ </para> <para> - Previously such push downs could generate errors. + Subqueries of a <literal>UNION</> or <literal>INTERSECT</> that + contain set-returning functions or volatile functions in their + <literal>SELECT</> lists could be improperly optimized, leading to + run-time errors or incorrect query results. </para> </listitem> <listitem> <para> - Fix rare <literal>GROUP BY</> query error caused by improperly - processed data type modifiers (Tom Lane) + Fix rare case of <quote>failed to locate grouping columns</> + planner failure (Tom Lane) </para> </listitem> @@ -171,8 +176,8 @@ <listitem> <para> - 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) </para> </listitem> @@ -303,8 +308,9 @@ <para> Specifically, lessen keyword restrictions for role names, language names, <command>EXPLAIN</> and <command>COPY</> options, and - <command>SET</> values. This allows <literal>COPY ... (FORMAT - BINARY)</> previously <literal>BINARY</> required single-quotes. + <command>SET</> values. This allows <literal>COPY ... (FORMAT + BINARY)</> to work as expected; previously <literal>BINARY</> needed + to be quoted. </para> </listitem> @@ -324,7 +330,7 @@ <listitem> <para> - Have <application>pg_upgrade</> use <command>>pg_dump + Make <application>pg_upgrade</> use <literal>pg_dump --quote-all-identifiers</> to avoid problems with keyword changes between releases (Tom Lane) </para> @@ -339,8 +345,9 @@ <listitem> <para> - Improve analyze statistics generation after a cancelled file truncate - request (Kevin Grittner) + Ensure that <command>VACUUM ANALYZE</> still runs the ANALYZE phase + if its attempt to truncate the file is cancelled due to lock conflicts + (Kevin Grittner) </para> </listitem> @@ -353,12 +360,16 @@ <listitem> <para> - Allow various spellings of infinity on all platforms (Tom Lane) + Ensure that floating-point data input accepts standard spellings + of <quote>infinity</> on all platforms (Tom Lane) </para> <para> - Supported infinity values are "inf", "+inf", "-inf", "infinity", - "+infinity", and "-infinity". + The C99 standard says that allowable spellings are <literal>inf</>, + <literal>+inf</>, <literal>-inf</>, <literal>infinity</>, + <literal>+infinity</>, and <literal>-infinity</>. Make sure we + recognize these even if the platform's <function>strtod</> function + doesn't. </para> </listitem> @@ -392,9 +403,8 @@ <listitem> <para> Update time zone data files to <application>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. </para> </listitem> diff --git a/doc/src/sgml/release-9.3.sgml b/doc/src/sgml/release-9.3.sgml index 4a7cac5cee..27d57bf09a 100644 --- a/doc/src/sgml/release-9.3.sgml +++ b/doc/src/sgml/release-9.3.sgml @@ -22,6 +22,11 @@ A dump/restore is not required for those running 9.3.X. </para> + <para> + However, if you use the <literal>hstore</> extension, see the + first changelog entry. + </para> + </sect2> <sect2> @@ -31,21 +36,33 @@ <listitem> <para> - Update hstore extension with JSON functionality (Andrew Dunstan) + Ensure new-in-9.3 JSON functionality is added to the <literal>hstore</> + extension during an update (Andrew Dunstan) </para> <para> - Users who installed hstore prior to 9.3.1 must execute: + Users who upgraded a pre-9.3 database containing <literal>hstore</> + should execute <programlisting> ALTER EXTENSION hstore UPDATE; </programlisting> - to add two new JSON functions and a cast. + after installing 9.3.1, to add two new JSON functions and a cast. + (If <literal>hstore</> is already up to date, this command does + nothing.) + </para> + </listitem> + + <listitem> + <para> + Fix memory leak when creating B-tree indexes on range columns + (Heikki Linnakangas) </para> </listitem> <listitem> <para> - Fix memory leak when creating range indexes (Heikki Linnakangas) + Fix memory leak caused by <function>lo_open()</function> failure + (Heikki Linnakangas) </para> </listitem> @@ -57,7 +74,7 @@ ALTER EXTENSION hstore UPDATE; <listitem> <para> - Fix libpq SSL deadlock bug (Stephen Frost) + Fix deadlock bug in libpq when using SSL (Stephen Frost) </para> </listitem> |