diff options
| -rw-r--r-- | doc/src/sgml/release.sgml | 489 |
1 files changed, 482 insertions, 7 deletions
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index fef5487758b..a29b2dd0c5e 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.488.2.24 2009/01/09 01:46:48 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.488.2.25 2009/01/30 00:37:52 tgl Exp $ --> <!-- Typical markup: @@ -63,6 +63,185 @@ do it for earlier branch release files. review, so each item is truly a community effort. </para> + <sect1 id="release-8-2-12"> + <title>Release 8.2.12</title> + + <note> + <title>Release date</title> + <simpara>2009-02-02</simpara> + </note> + + <para> + This release contains a variety of fixes from 8.2.11. + For information about new features in the 8.2 major release, see + <xref linkend="release-8-2">. + </para> + + <sect2> + <title>Migration to Version 8.2.12</title> + + <para> + A dump/restore is not required for those running 8.2.X. + However, if you are upgrading from a version earlier than 8.2.11, + see the release notes for 8.2.11. + </para> + + </sect2> + + <sect2> + <title>Changes</title> + + <itemizedlist> + + <listitem> + <para> + Improve handling of URLs in <function>headline()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Improve handling of overlength headlines in <function>headline()</> + function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + </para> + </listitem> + + <listitem> + <para> + Fix possible Assert failure if a statement executed in PL/pgSQL is + rewritten into another kind of statement, for example if an + <command>INSERT</> is rewritten into an <command>UPDATE</> (Heikki) + </para> + </listitem> + + <listitem> + <para> + Ensure that a snapshot is available to datatype input functions (Tom) + </para> + + <para> + This primarily affects domains that are declared with <literal>CHECK</> + constraints involving user-defined stable or immutable functions. Such + functions typically fail if no snapshot has been set. + </para> + </listitem> + + <listitem> + <para> + Make it safer for SPI-using functions to be used within datatype I/O; + in particular, to be used in domain check constraints (Tom) + </para> + </listitem> + + <listitem> + <para> + Avoid unnecessary locking of small tables in <command>VACUUM</> + (Heikki) + </para> + </listitem> + + <listitem> + <para> + Fix a problem that made <literal>UPDATE RETURNING tableoid</> + return zero instead of the correct OID (Tom) + </para> + </listitem> + + <listitem> + <para> + Fix planner misestimation of selectivity when transitive equality + is applied to an outer-join clause (Tom) + </para> + + <para> + This could result in bad plans for queries like + <literal>... from a left join b on a.a1 = b.b1 where a.a1 = 42 ...</> + </para> + </listitem> + + <listitem> + <para> + Improve optimizer's handling of long <literal>IN</> lists (Tom) + </para> + + <para> + This change avoids wasting large amounts of time on such lists + when constraint exclusion is enabled. + </para> + </listitem> + + <listitem> + <para> + Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables (Tom) + </para> + + <para> + Previously, large field values in a cursor result might be represented + as TOAST pointers, which would fail if the referenced table got dropped + before the cursor is read, or if the large value is deleted and then + vacuumed away. This cannot happen with an ordinary cursor, + but it could with a cursor that is held past its creating transaction. + </para> + </listitem> + + <listitem> + <para> + Fix memory leak when a set-returning function is terminated without + reading its whole result (Tom) + </para> + </listitem> + + <listitem> + <para> + Fix <filename>contrib/dblink</>'s + <function>dblink_get_result(text,bool)</> function (Joe) + </para> + </listitem> + + <listitem> + <para> + Fix possible garbage output from <filename>contrib/sslinfo</> functions + (Tom) + </para> + </listitem> + + <listitem> + <para> + Fix <application>configure</> script to properly report failure when + unable to obtain linkage information for PL/Perl (Andrew) + </para> + </listitem> + + <listitem> + <para> + Make all documentation reference <literal>pgsql-bugs</> and/or + <literal>pgsql-hackers</> as appropriate, instead of the + now-decommissioned <literal>pgsql-ports</> and <literal>pgsql-patches</> + mailing lists (Tom) + </para> + </listitem> + + <listitem> + <para> + Update time zone data files to <application>tzdata</> release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + </para> + </listitem> + + </itemizedlist> + + </sect2> + </sect1> + <sect1 id="release-8-2-11"> <title>Release 8.2.11</title> @@ -83,8 +262,9 @@ do it for earlier branch release files. <para> A dump/restore is not required for those running 8.2.X. However, if you are upgrading from a version earlier than 8.2.7, - see the release notes for 8.2.7. If you were running a previous - 8.2.X release, REINDEX all GiST indexes after the upgrade. + see the release notes for 8.2.7. Also, if you were running a previous + 8.2.X release, it is recommended to <command>REINDEX</> all GiST + indexes after the upgrade. </para> </sect2> @@ -102,7 +282,8 @@ do it for earlier branch release files. <para> This would result in index searches failing to find rows they - should have found. + should have found. Corrupted indexes can be fixed with + <command>REINDEX</>. </para> </listitem> @@ -4516,6 +4697,126 @@ do it for earlier branch release files. </sect2> </sect1> + <sect1 id="release-8-1-16"> + <title>Release 8.1.16</title> + + <note> + <title>Release date</title> + <simpara>2009-02-02</simpara> + </note> + + <para> + This release contains a variety of fixes from 8.1.15. + For information about new features in the 8.1 major release, see + <xref linkend="release-8-1">. + </para> + + <sect2> + <title>Migration to Version 8.1.16</title> + + <para> + A dump/restore is not required for those running 8.1.X. + However, if you are upgrading from a version earlier than 8.1.15, + see the release notes for 8.1.15. + </para> + + </sect2> + + <sect2> + <title>Changes</title> + + <itemizedlist> + + <listitem> + <para> + Fix crash in autovacuum (Alvaro) + </para> + + <para> + The crash occurs only after vacuuming a whole database for + anti-transaction-wraparound purposes, which means that it occurs + infrequently and is hard to track down. + </para> + </listitem> + + <listitem> + <para> + Improve handling of URLs in <function>headline()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Improve handling of overlength headlines in <function>headline()</> + function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + </para> + </listitem> + + <listitem> + <para> + Avoid unnecessary locking of small tables in <command>VACUUM</> + (Heikki) + </para> + </listitem> + + <listitem> + <para> + Ensure that the contents of a holdable cursor don't depend on the + contents of TOAST tables (Tom) + </para> + + <para> + Previously, large field values in a cursor result might be represented + as TOAST pointers, which would fail if the referenced table got dropped + before the cursor is read, or if the large value is deleted and then + vacuumed away. This cannot happen with an ordinary cursor, + but it could with a cursor that is held past its creating transaction. + </para> + </listitem> + + <listitem> + <para> + Fix uninitialized variables in <filename>contrib/tsearch2</>'s + <function>get_covers()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Fix <application>configure</> script to properly report failure when + unable to obtain linkage information for PL/Perl (Andrew) + </para> + </listitem> + + <listitem> + <para> + Make all documentation reference <literal>pgsql-bugs</> and/or + <literal>pgsql-hackers</> as appropriate, instead of the + now-decommissioned <literal>pgsql-ports</> and <literal>pgsql-patches</> + mailing lists (Tom) + </para> + </listitem> + + <listitem> + <para> + Update time zone data files to <application>tzdata</> release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + </para> + </listitem> + + </itemizedlist> + + </sect2> + </sect1> + <sect1 id="release-8-1-15"> <title>Release 8.1.15</title> @@ -4536,8 +4837,9 @@ do it for earlier branch release files. <para> A dump/restore is not required for those running 8.1.X. However, if you are upgrading from a version earlier than 8.1.2, - see the release notes for 8.1.2. If you were running a previous - 8.1.X release, REINDEX all GiST indexes after the upgrade. + see the release notes for 8.1.2. Also, if you were running a previous + 8.1.X release, it is recommended to <command>REINDEX</> all GiST + indexes after the upgrade. </para> </sect2> @@ -4555,7 +4857,8 @@ do it for earlier branch release files. <para> This would result in index searches failing to find rows they - should have found. + should have found. Corrupted indexes can be fixed with + <command>REINDEX</>. </para> </listitem> @@ -8587,6 +8890,92 @@ psql -t -f fixseq.sql db1 | psql -e db1 </sect2> </sect1> + <sect1 id="release-8-0-20"> + <title>Release 8.0.20</title> + + <note> + <title>Release date</title> + <simpara>2009-02-02</simpara> + </note> + + <para> + This release contains a variety of fixes from 8.0.19. + For information about new features in the 8.0 major release, see + <xref linkend="release-8-0">. + </para> + + <sect2> + <title>Migration to Version 8.0.20</title> + + <para> + A dump/restore is not required for those running 8.0.X. + However, if you are upgrading from a version earlier than 8.0.6, + see the release notes for 8.0.6. + </para> + + </sect2> + + <sect2> + <title>Changes</title> + + <itemizedlist> + + <listitem> + <para> + Improve handling of URLs in <function>headline()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Improve handling of overlength headlines in <function>headline()</> + function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + </para> + </listitem> + + <listitem> + <para> + Avoid unnecessary locking of small tables in <command>VACUUM</> + (Heikki) + </para> + </listitem> + + <listitem> + <para> + Fix uninitialized variables in <filename>contrib/tsearch2</>'s + <function>get_covers()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Make all documentation reference <literal>pgsql-bugs</> and/or + <literal>pgsql-hackers</> as appropriate, instead of the + now-decommissioned <literal>pgsql-ports</> and <literal>pgsql-patches</> + mailing lists (Tom) + </para> + </listitem> + + <listitem> + <para> + Update time zone data files to <application>tzdata</> release 2009a (for + Kathmandu and historical DST corrections in Switzerland, Cuba) + </para> + </listitem> + + </itemizedlist> + + </sect2> + </sect1> + <sect1 id="release-8-0-19"> <title>Release 8.0.19</title> @@ -12980,6 +13369,92 @@ typedefs (Michael)</para></listitem> </sect2> </sect1> + <sect1 id="release-7-4-24"> + <title>Release 7.4.24</title> + + <note> + <title>Release date</title> + <simpara>2009-02-02</simpara> + </note> + + <para> + This release contains a variety of fixes from 7.4.23. + For information about new features in the 7.4 major release, see + <xref linkend="release-7-4">. + </para> + + <sect2> + <title>Migration to Version 7.4.24</title> + + <para> + A dump/restore is not required for those running 7.4.X. + However, if you are upgrading from a version earlier than 7.4.11, + see the release notes for 7.4.11. + </para> + + </sect2> + + <sect2> + <title>Changes</title> + + <itemizedlist> + + <listitem> + <para> + Improve handling of URLs in <function>headline()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Improve handling of overlength headlines in <function>headline()</> + function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Prevent possible Assert failure or misconversion if an encoding + conversion is created with the wrong conversion function for the + specified pair of encodings (Tom, Heikki) + </para> + </listitem> + + <listitem> + <para> + Avoid unnecessary locking of small tables in <command>VACUUM</> + (Heikki) + </para> + </listitem> + + <listitem> + <para> + Fix uninitialized variables in <filename>contrib/tsearch2</>'s + <function>get_covers()</> function (Teodor) + </para> + </listitem> + + <listitem> + <para> + Fix bug in <function>to_char()</>'s handling of <literal>TH</> + format codes (Andreas Scherbaum) + </para> + </listitem> + + <listitem> + <para> + Make all documentation reference <literal>pgsql-bugs</> and/or + <literal>pgsql-hackers</> as appropriate, instead of the + now-decommissioned <literal>pgsql-ports</> and <literal>pgsql-patches</> + mailing lists (Tom) + </para> + </listitem> + + </itemizedlist> + + </sect2> + </sect1> + <sect1 id="release-7-4-23"> <title>Release 7.4.23</title> |