docs: update release notes for 8.4.18, 9.0.14, 9.1.10, 9.2.5, 9.3.1

2 files changed, 450 insertions, 0 deletions

diff --git a/doc/src/sgml/release-8.4.sgml b/doc/src/sgml/release-8.4.sgml
index 506743cd2dc..ae8deb9ec0d 100644
--- a/doc/src/sgml/release-8.4.sgml
+++ b/doc/src/sgml/release-8.4.sgml
@@ -1,6 +1,199 @@
 <!-- doc/src/sgml/release-8.4.sgml -->
 <!-- See header comment in release.sgml about typical markup -->
 
+ <sect1 id="release-8-4-18">
+  <title>Release 8.4.18</title>
+
+  <note>
+  <title>Release Date</title>
+  <simpara>2013-10-10</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 8.4.17.
+   For information about new features in the 8.4 major release, see
+   <xref linkend="release-8-4">.
+  </para>
+
+  <sect2>
+   <title>Migration to Version 8.4.18</title>
+
+   <para>
+    A dump/restore is not required for those running 8.4.X.
+   </para>
+
+   <para>
+    Also, if you are upgrading from a version earlier than 8.4.10,
+    see the release notes for 8.4.10.
+   </para>
+
+  </sect2>
+
+  <sect2>
+   <title>Changes</title>
+
+   <itemizedlist>
+
+    <listitem>
+     <para>
+      Prevent downcasing of non-ASCII non-double-quoted identifiers in
+      multi-byte encodings (Andrew Dunstan)
+     </para>
+
+     <para>
+      The previous behavior was wrong and confusing.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix memory leak caused by <function>lo_open()</function> failure
+      (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix memory overcommit bug when <varname>work_mem</> is using more
+      than 24GB of memory (Stephen Frost)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix libpq SSL deadlock bug (Stephen Frost)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Properly compute row estimates for boolean columns containing many NULL
+      values (Andrew Gierth)
+     </para>
+
+     <para>
+      Previously tests like <literal>col IS NOT TRUE</> and <literal>col IS
+      NOT FALSE</> did not properly factor in NULL values when estimating
+      plan costs.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent pushing down <literal>WHERE</> clauses into unsafe
+      <literal>UNION/INTERSECT</> subqueries (Tom Lane)
+     </para>
+
+     <para>
+      Previously such push downs could generate errors.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix rare <literal>GROUP BY</> query error caused by improperly processed date type
+      modifiers (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Allow view dump code to better handle dropped columns on base tables
+      (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible deadlock during concurrent <command>CREATE INDEX
+      CONCURRENTLY</> operations (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>regexp_matches()</> handling of zero-length matches
+      (Jeevan Chalke)
+     </para>
+
+     <para>
+      Previously, zero-length matches like '^' could return too many matches.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix crash for overly-complex regular expressions (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix regular expression match failures for back references combined with
+      non-greedy quantifiers (Jeevan Chalke)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent <command>CREATE FUNCTION</> from checking <command>SET</>
+      variables unless function body checking is enabled (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>pgp_pub_decrypt()</> so it works for secret keys with
+      passwords (Marko Kreen)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Remove rare inaccurate warning during vacuum of index-less tables
+      (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Avoid possible failure when performing transaction control commands (e.g
+      <command>ROLLBACK</>) in prepared queries (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Allow various spellings of infinity on all platforms (Tom Lane)
+     </para>
+
+     <para>
+      Supported infinity values are "inf", "+inf", "-inf", "infinity",
+      "+infinity", and "-infinity".
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Expand ability to compare rows to records and arrays (Rafal Rzepecki,
+      Tom Lane)
+     </para>
+    </listitem>
+
+    <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)
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-8-4-17">
   <title>Release 8.4.17</title>
 
diff --git a/doc/src/sgml/release-9.0.sgml b/doc/src/sgml/release-9.0.sgml
index d68d5801d43..4664df33b68 100644
--- a/doc/src/sgml/release-9.0.sgml
+++ b/doc/src/sgml/release-9.0.sgml
@@ -1,6 +1,263 @@
 <!-- doc/src/sgml/release-9.0.sgml -->
 <!-- See header comment in release.sgml about typical markup -->
 
+ <sect1 id="release-9-0-14">
+  <title>Release 9.0.14</title>
+
+  <note>
+  <title>Release Date</title>
+  <simpara>2013-10-10</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 9.0.13.
+   For information about new features in the 9.0 major release, see
+   <xref linkend="release-9-0">.
+  </para>
+
+  <sect2>
+   <title>Migration to Version 9.0.14</title>
+
+   <para>
+    A dump/restore is not required for those running 9.0.X.
+   </para>
+
+   <para>
+    Also, if you are upgrading from a version earlier than 9.0.6,
+    see the release notes for 9.0.6.
+   </para>
+
+  </sect2>
+
+  <sect2>
+   <title>Changes</title>
+
+   <itemizedlist>
+
+    <listitem>
+     <para>
+      Prevent downcasing of non-ASCII non-double-quoted identifiers in
+      multi-byte encodings (Andrew Dunstan)
+     </para>
+
+     <para>
+      The previous behavior was wrong and confusing.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix checkpoint memory leak in background writer when <literal>wal_level =
+      hot_standby</> (Naoya Anzai)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix memory leak caused by <function>lo_open()</function> failure
+      (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix memory overcommit bug when <varname>work_mem</> is using more
+      than 24GB of memory (Stephen Frost)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix libpq SSL deadlock bug (Stephen Frost)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible SSL network stack corruption in threaded libpq applications
+      (Nick Phillips, Stephen Frost)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Properly compute row estimates for boolean columns containing many NULL
+      values (Andrew Gierth)
+     </para>
+
+     <para>
+      Previously tests like <literal>col IS NOT TRUE</> and <literal>col IS
+      NOT FALSE</> did not properly factor in NULL values when estimating
+      plan costs.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent pushing down <literal>WHERE</> clauses into unsafe
+      <literal>UNION/INTERSECT</> subqueries (Tom Lane)
+     </para>
+
+     <para>
+      Previously such push downs could generate errors.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix rare <literal>GROUP BY</> query error caused by improperly processed date type
+      modifiers (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Allow view dump code to better handle dropped columns on base tables
+      (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Properly record index comments created using <literal>UNIQUE</>
+      and <literal>PRIMARY KEY</> syntax (Andres Freund)
+     </para>
+
+     <para>
+      This fixes a parallel <application>pg_restore</> failure.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <command>REINDEX TABLE</> and <command>REINDEX DATABASE</>
+      to properly revalidate constraints and mark invalidated indexes as
+      valid (Noah Misch)
+     </para>
+
+     <para>
+      <command>REINDEX INDEX</> has always worked properly.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible deadlock during concurrent <command>CREATE INDEX
+      CONCURRENTLY</> operations (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>regexp_matches()</> handling of zero-length matches
+      (Jeevan Chalke)
+     </para>
+
+     <para>
+      Previously, zero-length matches like '^' could return too many matches.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix crash for overly-complex regular expressions (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix regular expression match failures for back references combined with
+      non-greedy quantifiers (Jeevan Chalke)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Prevent <command>CREATE FUNCTION</> from checking <command>SET</>
+      variables unless function body checking is enabled (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Allow <command>ALTER DEFAULT PRIVILEGES</> to operate on schemas
+      without requiring CREATE permission (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Loosen restriction on keywords used in queries (Tom Lane)
+     </para>
+
+     <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.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>pgp_pub_decrypt()</> so it works for secret keys with
+      passwords (Marko Kreen)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Remove rare inaccurate warning during vacuum of index-less tables
+      (Heikki Linnakangas)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Improve analyze statistics generation after a cancelled file truncate
+      request (Kevin Grittner)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Avoid possible failure when performing transaction control commands (e.g
+      ROLLBACK) in prepared queries (Tom Lane)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Allow various spellings of infinity on all platforms (Tom Lane)
+     </para>
+
+     <para>
+      Supported infinity values are "inf", "+inf", "-inf", "infinity",
+      "+infinity", and "-infinity".
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Expand ability to compare rows to records and arrays (Rafal Rzepecki,
+      Tom Lane)
+     </para>
+    </listitem>
+
+    <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)
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-9-0-13">
   <title>Release 9.0.13</title>