Create release notes for 8.1.6.

1 files changed, 412 insertions, 1 deletions

diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml
index 7c8715a4a4..fe5d65308d 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.400.2.33 2006/11/23 03:31:04 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.400.2.34 2007/01/05 20:03:46 momjian Exp $ -->
 <!--
 
 Typical markup:
@@ -19,6 +19,151 @@ For new features, add links to the documentation sections.
 <appendix id="release">
  <title>Release Notes</title>
 
+  <sect1 id="release-8-1-6">
+   <title>Release 8.1.6</title>
+
+   <note>
+   <title>Release date</title>
+   <simpara>2007-01-08</simpara>
+   </note>
+
+   <para>
+    This release contains a variety of fixes from 8.1.5.
+   </para>
+
+   <sect2>
+    <title>Migration to version 8.1.6</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.2,
+     see the release notes for 8.1.2.
+    </para>
+
+   </sect2>
+
+   <sect2>
+    <title>Changes</title>
+
+    <itemizedlist>
+
+     <listitem>
+      <para>
+       Improve handling of <function>getaddrinfo()</> on AIX (Tom)
+      </para>
+
+      <para>
+       This fixes a problem with starting the statistics collector,
+       among other things.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix <application>pg_restore</> so it can restore a tar-format backup
+       that contains large object comments (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix <link linkend="SQL-VACUUM"><command>VACUUM</></link> to recover from
+       a rare problem during index page deletion/split (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix point-in-time-recovery bug where stale status files could prevent
+       restore (Simon, Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix error when constructing an <literal>ARRAY[]</> made up of multiple empty
+       elements (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix ecpg memory leak during connection (Michael)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Improve savepoint and multi-transction row locking algorithms to avoid
+       erroneous deadlock cases (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix problem with extending hash indexes that span multiple 1-gigabyte
+       segments (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix problem where truncation of a multi-gigabyte table might cause
+       consistency problems with other backends (Tom)
+      </para>
+      </listitem>
+
+     <listitem>
+      <para>
+       Fix for Darwin/OS-X compiles (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       <function>to_number()</> and <function>to_char(numeric)</>
+       are now <literal>STABLE</>, not <literal>IMMUTABLE</>, for
+       new <link linkend="APP-INITDB"><application>initdb</></link>
+       installs (Tom)
+      </para>
+
+      <para>
+       This is because <link
+       linkend="guc-lc-numeric"><varname>lc_numeric</></link> can potentially
+       change the output of the functions.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Update timezone database, particularly for Western Australia,
+       which has a new daylight savings date  (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Document a risk that if a row is locked inside multiple sub-transactions
+       in the same transaction, and a sub-transaction is rolled back, the row
+       lock is lost (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Improve index usage of regular expressions that use parentheses (Tom)
+      </para>
+
+      <para>
+       This improves <application>psql</> <literal>\d</> performance also.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect2>
+  </sect1>
+ 
   <sect1 id="release-8-1-5">
    <title>Release 8.1.5</title>
 
@@ -2679,6 +2824,124 @@ psql -t -f fixseq.sql db1 | psql -e db1
    </sect2>
   </sect1>
 
+  <sect1 id="release-8-0-10">
+   <title>Release 8.0.10</title>
+
+   <note>
+   <title>Release date</title>
+   <simpara>2007-01-08</simpara>
+   </note>
+
+   <para>
+    This release contains a variety of fixes from 8.0.9.
+   </para>
+
+   <sect2>
+    <title>Migration to version 8.0.10</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 <function>getaddrinfo()</> on AIX (Tom)
+      </para>
+
+      <para>
+       This is intended to fix problems with starting the statistics
+       collector, among other things.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix <link linkend="SQL-VACUUM"><command>VACUUM</></link> to recover from
+       a rare problem during index page deletion/split (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix error when constructing an <literal>ARRAY[]</> made up of multiple
+       empty elements (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix ecpg memory leak during connection (Michael)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix problem with extending hash indexes that span multiple 1-gigabyte
+       segments (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix problem where truncation of a multi-gigabyte table might cause
+       consistency problems with other backends (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       <function>to_number()</> and <function>to_char(numeric)</>
+       are now <literal>STABLE</>, not <literal>IMMUTABLE</>, for
+       new <link linkend="APP-INITDB"><application>initdb</></link>
+       installs (Tom)
+      </para>
+
+      <para>
+       This is because <link
+       linkend="guc-lc-numeric"><varname>lc_numeric</></link> can potentially
+       change the output of the functions.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Update timezone database, particularly for Western Australia,
+       which has a new daylight savings date  (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Document a risk that if a row is locked inside multiple sub-transactions
+       in the same transaction, and a sub-transaction is rolled back, the row
+       lock is lost (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Improve index usage of regular expressions that use parentheses (Tom)
+      </para>
+
+      <para>
+       This improves <application>psql</> <literal>\d</> performance also.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect2>
+  </sect1>
+ 
   <sect1 id="release-8-0-9">
    <title>Release 8.0.9</title>
 
@@ -5886,6 +6149,96 @@ typedefs (Michael)</para></listitem>
    </sect2>
   </sect1>
 
+  <sect1 id="release-7-4-15">
+   <title>Release 7.4.15</title>
+
+   <note>
+   <title>Release date</title>
+   <simpara>2007-01-08</simpara>
+   </note>
+
+   <para>
+    This release contains a variety of fixes from 7.4.14.
+   </para>
+
+   <sect2>
+    <title>Migration to version 7.4.15</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 <function>getaddrinfo()</> on AIX (Tom)
+      </para>
+
+      <para>
+       This fixes a problem with starting the statistics collector,
+       among other things.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix <link linkend="SQL-VACUUM"><command>VACUUM</></link> to recover from
+       a rare problem during index page deletion/split (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix error when constructing an <literal>ARRAY[]</> made up of multiple empty
+       elements (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Fix problem with extending hash indexes that span multiple 1-gigabyte
+       segments (Tom)
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       <function>to_number()</> and <function>to_char(numeric)</>
+       are now <literal>STABLE</>, not <literal>IMMUTABLE</>, for
+       new <link linkend="APP-INITDB"><application>initdb</></link>
+       installs (Tom)
+      </para>
+
+      <para>
+       This is because <link
+       linkend="guc-lc-numeric"><varname>lc_numeric</></link> can potentially
+       change the output of the functions.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Improve index usage of regular expressions that use parentheses (Tom)
+      </para>
+
+      <para>
+       This improves <application>psql</> <literal>\d</> performance also.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect2>
+  </sect1>
+ 
   <sect1 id="release-7-4-14">
    <title>Release 7.4.14</title>
 
@@ -8845,6 +9198,64 @@ DROP SCHEMA information_schema CASCADE;
   </sect2>
  </sect1>
 
+  <sect1 id="release-7-3-17">
+   <title>Release 7.3.17</title>
+
+   <note>
+   <title>Release date</title>
+   <simpara>2007-01-08</simpara>
+   </note>
+
+   <para>
+    This release contains a variety of fixes from 7.3.16.
+   </para>
+
+   <sect2>
+    <title>Migration to version 7.3.17</title>
+
+    <para>
+     A dump/restore is not required for those running 7.3.X.  However,
+     if you are upgrading from a version earlier than 7.3.13, see the release
+     notes for 7.3.13.
+    </para>
+
+   </sect2>
+
+   <sect2>
+    <title>Changes</title>
+
+    <itemizedlist>
+
+     <listitem>
+      <para>
+       <function>to_number()</> and <function>to_char(numeric)</>
+       are now <literal>STABLE</>, not <literal>IMMUTABLE</>, for
+       new <link linkend="APP-INITDB"><application>initdb</></link>
+       installs (Tom)
+      </para>
+
+      <para>
+       This is because <link
+       linkend="guc-lc-numeric"><varname>lc_numeric</></link> can potentially
+       change the output of the functions.
+      </para>
+     </listitem>
+
+     <listitem>
+      <para>
+       Improve index usage of regular expressions that use parentheses (Tom)
+      </para>
+
+      <para>
+       This improves <application>psql</> <literal>\d</> performance also.
+      </para>
+     </listitem>
+
+    </itemizedlist>
+
+   </sect2>
+  </sect1>
+ 
   <sect1 id="release-7-3-16">
    <title>Release 7.3.16</title>