Update release notes for 9.2.3, 9.1.8, 9.0.12, 8.4.16, 8.3.23.

1 files changed, 309 insertions, 0 deletions

diff --git a/doc/src/sgml/release-9.1.sgml b/doc/src/sgml/release-9.1.sgml
index 1143fdfdcd..897b584247 100644
--- a/doc/src/sgml/release-9.1.sgml
+++ b/doc/src/sgml/release-9.1.sgml
@@ -1,6 +1,315 @@
 <!-- doc/src/sgml/release-9.1.sgml -->
 <!-- See header comment in release.sgml about typical markup -->
 
+ <sect1 id="release-9-1-8">
+  <title>Release 9.1.8</title>
+
+  <note>
+  <title>Release Date</title>
+  <simpara>2013-02-07</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 9.1.7.
+   For information about new features in the 9.1 major release, see
+   <xref linkend="release-9-1">.
+  </para>
+
+  <sect2>
+   <title>Migration to Version 9.1.8</title>
+
+   <para>
+    A dump/restore is not required for those running 9.1.X.
+   </para>
+
+   <para>
+    However, if you are upgrading from a version earlier than 9.1.6,
+    see the release notes for 9.1.6.
+   </para>
+
+  </sect2>
+
+  <sect2>
+   <title>Changes</title>
+
+   <itemizedlist>
+
+    <listitem>
+     <para>
+      Fix multiple problems in detection of when a consistent database
+      state has been reached during WAL replay (Fujii Masao, Heikki
+      Linnakangas, Simon Riggs, Andres Freund)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Update minimum recovery point when truncating a relation file (Heikki
+      Linnakangas)
+     </para>
+
+     <para>
+      Once data has been discarded, it's no longer safe to stop recovery at
+      an earlier point in the timeline.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix recycling of WAL segments after changing recovery target timeline
+      (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix missing cancellations in hot standby mode (Noah Misch, Simon Riggs)
+     </para>
+
+     <para>
+      The need to cancel conflicting hot-standby queries would sometimes be
+      missed, allowing those queries to see inconsistent data.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent recovery pause feature from pausing before users can connect
+      (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix SQL grammar to allow subscripting or field selection from a
+      sub-SELECT result (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix performance problems with autovacuum truncation in busy workloads
+      (Jan Wieck)
+     </para>
+
+     <para>
+      Truncation of empty pages at the end of a table requires exclusive
+      lock, but autovacuum was coded to fail (and release the table lock)
+      when there are conflicting lock requests.  Under load, it is easily
+      possible that truncation would never occur, resulting in table bloat.
+      Fix by performing a partial truncation, releasing the lock, then
+      attempting to re-acquire the lock and continue.  This fix also greatly
+      reduces the average time before autovacuum releases the lock after a
+      conflicting request arrives.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Protect against race conditions when scanning
+      <structname>pg_tablespace</> (Stephen Frost, Tom Lane)
+     </para>
+
+     <para>
+      <command>CREATE DATABASE</> and <command>DROP DATABASE</> could
+      misbehave if there were concurrent updates of
+      <structname>pg_tablespace</> entries.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent <command>DROP OWNED</> from trying to drop whole databases or
+      tablespaces (&Aacute;lvaro Herrera)
+     </para>
+
+     <para>
+      For safety, ownership of these objects must be reassigned, not dropped.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix error in <link
+      linkend="guc-vacuum-freeze-table-age"><varname>vacuum_freeze_table_age</></link>
+      implementation (Andres Freund)
+     </para>
+
+     <para>
+      The main consequence of this mistake is that lowering <link
+      linkend="guc-vacuum-freeze-min-age"><varname>vacuum_freeze_min_age</></link>
+      would cause full-table vacuuming scans to occur much more frequently
+      than intended.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent misbehavior when a <symbol>RowExpr</> or <symbol>XmlExpr</>
+      is parse-analyzed twice (Andres Freund, Tom Lane)
+     </para>
+
+     <para>
+      This mistake could be user-visible in contexts such as
+      <literal>CREATE TABLE LIKE INCLUDING INDEXES</>.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Improve defenses against integer overflow in hashtable sizing
+      calculations (Jeff Davis)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix failure to ignore leftover temporary tables after a server crash
+      (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Reject out-of-range dates in <function>to_date()</> (Hitoshi Harada)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>pg_extension_config_dump()</> to handle
+      extension-update cases properly (Tom Lane)
+     </para>
+
+     <para>
+      This function will now replace any existing entry for the target
+      table, making it usable in extension update scripts.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix PL/Python's handling of functions used as triggers on multiple
+      tables (Andres Freund)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Ensure that non-ASCII prompt strings are translated to the correct
+      code page on Windows (Alexander Law, Noah Misch)
+     </para>
+
+     <para>
+      This bug affected <application>psql</> and some other client programs.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible crash in <application>psql</>'s <command>\?</> command
+      when not connected to a database (Meng Qingzhong)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible error if a relation file is removed while
+      <application>pg_basebackup</> is running (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Make <application>pg_dump</> exclude data of unlogged tables when
+      running on a hot-standby server (Magnus Hagander)
+     </para>
+
+     <para>
+      This would fail anyway because the data is not available on the standby
+      server, so it seems most convenient to assume
+      <option>--no-unlogged-table-data</> automatically.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>pg_upgrade</> to deal with invalid indexes safely
+      (Bruce Momjian)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix one-byte buffer overrun in <application>libpq</>'s
+      <function>PQprintTuples</> (Xi Wang)
+     </para>
+
+     <para>
+      This ancient function is not used anywhere by
+      <productname>PostgreSQL</> itself, but it might still be used by some
+      client code.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Make <application>ecpglib</> use translated messages properly
+      (Chen Huajun)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Properly install <application>ecpg_compat</> and
+      <application>pgtypes</> libraries on MSVC (Jiang Guiqing)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Include our version of <function>isinf()</> in
+      <application>libecpg</> if it's not provided by the system
+      (Jiang Guiqing)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Rearrange configure's tests for supplied functions so it is not
+      fooled by bogus exports from libedit/libreadline (Christoph Berg)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Ensure Windows build number increases over time (Magnus Hagander)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Make <application>pgxs</> build executables with the right
+      <literal>.exe</> suffix when cross-compiling for Windows
+      (Zoltan Boszormenyi)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Add new timezone abbreviation <literal>FET</> (Tom Lane)
+     </para>
+
+     <para>
+      This is now used in some eastern-European time zones.
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-9-1-7">
   <title>Release 9.1.7</title>