[Trad] [svn:pgfr] r1057 - in traduc/branches/bv82x/manuel: . ref

svncommit at kryskool.org svncommit at kryskool.org
Ven 6 Juin 15:15:58 CEST 2008


Auteur: gleu
Date: 2008-06-06 15:15:56 +0200 (ven, 06 jun 2008)
Nouvelle Révision: 1057

Modification:
   traduc/branches/bv82x/manuel/external-projects.xml
   traduc/branches/bv82x/manuel/ref/grant.xml
   traduc/branches/bv82x/manuel/release.xml
   traduc/branches/bv82x/manuel/version.xml
Log:
Mise à jour version 8.2.8.


Modified: traduc/branches/bv82x/manuel/external-projects.xml
===================================================================
--- traduc/branches/bv82x/manuel/external-projects.xml	2008-06-06 12:59:58 UTC (rev 1056)
+++ traduc/branches/bv82x/manuel/external-projects.xml	2008-06-06 13:15:56 UTC (rev 1057)
@@ -143,7 +143,7 @@
       <entry>psqlODBC</entry>
       <entry>ODBC</entry>
       <entry>Pilote ODBC le plus communément utilisé </entry>
-      <entry><ulink url="http://odbc.postgresql.org/">http://odbc.postgresql.org/</ulink></entry>
+      <entry><ulink url="http://psqlodbc.projects.postgresql.org/">http://psqlodbc.projects.postgresql.org/</ulink></entry>
      </row>
 
      <row>

Modified: traduc/branches/bv82x/manuel/ref/grant.xml
===================================================================
--- traduc/branches/bv82x/manuel/ref/grant.xml	2008-06-06 12:59:58 UTC (rev 1056)
+++ traduc/branches/bv82x/manuel/ref/grant.xml	2008-06-06 13:15:56 UTC (rev 1057)
@@ -140,10 +140,14 @@
      <term>SELECT</term>
      <listitem>
       <para>
-       Autorise <xref linkend="sql-select" endterm="sql-select-title"/> sur
-       toutes les colonnes de la table, vue ou séquence indiquée. Autorise
-       aussi l'utilisation de <xref linkend="sql-copy" endterm="sql-copy-title"/>
-       TO. Pour les séquences, ce droit autorise aussi l'utilisation de la
+       Autorise <xref linkend="sql-select" endterm="sql-select-title"/> parmi
+       toutes les colonnes de la table, vue ou séquence spécifiée. Autorise
+       aussi l'utilisation de <xref linkend="sql-copy" endterm="sql-copy-title">
+       TO.
+       Ce droit est aussi nécessaire pour référencer des valeurs de colonnes
+       existantes avec <xref linkend="sql-update" endterm="sql-update-title"/>
+       ou <xref linkend="sql-delete" endterm="sql-delete-title"/>.
+       Pour les séquences, ce droit permet aussi l'utilisation de la
        fonction <function>currval</function>.
       </para>
      </listitem>
@@ -165,9 +169,13 @@
      <listitem>
       <para>
        Autorise <xref linkend="sql-update" endterm="sql-update-title"/> sur toute
-       colonne de la table indiquée. <literal>SELECT ... FOR UPDATE</literal>
-       et <literal>SELECT ... FOR SHARE</literal>
-       requièrent également ce droit (en plus du droit <literal>SELECT</literal>).
+       colonne de la table spécifiée. (En fait, toute commande
+       <command>UPDATE</command> non triviale nécessite aussi le droit
+       <literal>SELECT</literal> car elle doit référencer les colonnes pour
+       déterminer les lignes à mettre à jour et/ou calculer les nouvelles
+       valeurs des colonnes.) <literal>SELECT ... FOR UPDATE</literal>
+       et <literal>SELECT ... FOR SHARE</literal> requièrent également ce droit
+       en plus du droit <literal>SELECT</literal>.
        Pour les séquences, ce droit autorise l'utilisation des fonctions
        <function>nextval</function> et <function>setval</function>.
       </para>
@@ -179,7 +187,10 @@
      <listitem>
       <para>
        Autorise <xref linkend="sql-delete" endterm="sql-delete-title"/> d'une
-       ligne sur la table indiquée.
+       ligne sur la table indiquée. (En fait, toute commande
+       <command>DELETE</command> non triviale nécessite aussi le droit
+       <literal>SELECT</literal> car elle doit référencer les colonnes pour
+       déterminer les lignes à supprimer.)
       </para>
      </listitem>
     </varlistentry>
@@ -242,7 +253,7 @@
      <listitem>
       <para>
        Autorise la création de tables temporaires lors de l'utilisation
-       de la base de données.
+       de la base de données spécifiée.
       </para>
      </listitem>
     </varlistentry>

Modified: traduc/branches/bv82x/manuel/release.xml
===================================================================
--- traduc/branches/bv82x/manuel/release.xml	2008-06-06 12:59:58 UTC (rev 1056)
+++ traduc/branches/bv82x/manuel/release.xml	2008-06-06 13:15:56 UTC (rev 1057)
@@ -64,6 +64,201 @@
    review, so each item is truly a community effort.
   </para>
 
+ <sect1 id="release-8-2-8">
+  <title>Release 8.2.8</title>
+
+  <note>
+  <title>Release date</title>
+  <simpara>2008-06-09</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 8.2.7.
+   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.8</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.7,
+    see the release notes for 8.2.7.
+   </para>
+
+  </sect2>
+
+  <sect2>
+   <title>Changes</title>
+
+   <itemizedlist>
+
+    <listitem>
+     <para>
+      Fix <literal>ERRORDATA_STACK_SIZE exceeded</literal> crash that
+      occurred on Windows when using UTF-8 database encoding and a different
+      client encoding (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <command>ALTER TABLE ADD COLUMN ... PRIMARY KEY</command> so that the new
+      column is correctly checked to see if it's been initialized to all
+      non-nulls (Brendan Jurd)
+     </para>
+
+     <para>
+      Previous versions neglected to check this requirement at all.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible <command>CREATE TABLE</command> failure when inheriting the
+      <quote>same</quote> constraint from multiple parent relations that
+      inherited that constraint from a common ancestor (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <function>pg_get_ruledef()</function> to show the alias, if any, attached
+      to the target table of an <command>UPDATE</command> or <command>DELETE</command>
+      (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix GIN bug that could result in a <literal>too many LWLocks
+      taken</literal> failure (Teodor)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Avoid possible crash when decompressing corrupted data
+      (Zdenek Kotala)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Repair two places where SIGTERM exit of a backend could leave corrupted
+      state in shared memory (Tom)
+     </para>
+
+     <para>
+      Neither case is very important if SIGTERM is used to shut down the
+      whole database cluster together, but there was a problem if someone
+      tried to SIGTERM individual backends.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix conversions between ISO-8859-5 and other encodings to handle
+      Cyrillic <quote>Yo</quote> characters (<literal>e</literal> and <literal>E</literal> with
+      two dots) (Sergey Burladyan)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix several datatype input functions, notably <function>array_in()</function>,
+      that were allowing unused bytes in their results to contain
+      uninitialized, unpredictable values (Tom)
+     </para>
+
+     <para>
+      This could lead to failures in which two apparently identical literal
+      values were not seen as equal, resulting in the parser complaining
+      about unmatched <literal>ORDER BY</literal> and <literal>DISTINCT</literal>
+      expressions.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a corner case in regular-expression substring matching
+      (<literal>substring(<replaceable>string</replaceable> from
+      <replaceable>pattern</replaceable>)</literal>) (Tom)
+     </para>
+
+     <para>
+      The problem occurs when there is a match to the pattern overall but
+      the user has specified a parenthesized subexpression and that
+      subexpression hasn't got a match.  An example is
+      <literal>substring('foo' from 'foo(bar)?')</literalv>.
+      This should return NULL, since <literal>(bar)</literal> isn't matched, but
+      it was mistakenly returning the whole-pattern match instead (ie,
+      <literal>foo</literal>).
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Update time zone data files to <application>tzdata</application> release 2008c (for
+      DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, and
+      Argentina/San_Luis)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix incorrect result from <application>ecpg</application>'s
+      <function>PGTYPEStimestamp_sub()</function> function (Michael)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix broken GiST comparison function for <filename>contrib/tsearch2</filename>'s
+      <type>tsquery</type> type (Teodor)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible crashes in <filename>contrib/cube</filename> functions (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix core dump in <filename>contrib/xml2</filename>'s
+      <function>xpath_table()</function> function when the input query returns a
+      NULL value (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <filename>contrib/xml2</filename>'s makefile to not override
+      <literal>CFLAGS</literal> (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <literal>DatumGetBool</literal> macro to not fail with <application>gcc</application>
+      4.3 (Tom)
+     </para>
+
+     <para>
+      This problem affects <quote>old style</quote> (V0) C functions that
+      return boolean.  The fix is already in 8.3, but the need to
+      back-patch it was not realized at the time.
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-8-2-7">
   <title>Release 8.2.7</title>
 
@@ -74,6 +269,8 @@
 
   <para>
    This release contains a variety of fixes from 8.2.6.
+   For information about new features in the 8.2 major release, see
+   <xref linkend="release-8-2"/>.
   </para>
 
   <sect2>
@@ -342,6 +539,8 @@
   <para>
    Cette version contient divers correctifs de la version 8.2.5,
    et inclut des corrections pour des failles de sécurité importantes.
+   For information about new features in the 8.2 major release, see
+   <xref linkend="release-8-2"/>.
   </para>
 
   <sect2>
@@ -660,6 +859,8 @@
 
    <para>
     Cette version contient divers correctifs de la version 8.2.4.
+    For information about new features in the 8.2 major release, see
+    <xref linkend="release-8-2"/>.
    </para>
 
    <sect2>
@@ -856,6 +1057,8 @@
    <para>
     Cette version contient quelques corrections de la 8.2.3, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 8.2 major release, see
+    <xref linkend="release-8-2"/>.
    </para>
 
    <sect2>
@@ -1007,6 +1210,8 @@
 
    <para>
     Cette version contient deux corrections de la 8.2.2.
+    For information about new features in the 8.2 major release, see
+    <xref linkend="release-8-2"/>.
    </para>
 
    <sect2>
@@ -1054,6 +1259,8 @@
    <para>
     Cette version contient quelques corrections de la 8.2.1, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 8.2 major release, see
+    <xref linkend="release-8-2"/>.
    </para>
 
    <sect2>
@@ -1217,6 +1424,8 @@
 
    <para>
     Cette version contient quelques corrections de la 8.2.
+    For information about new features in the 8.2 major release, see
+    <xref linkend="release-8-2"/>.
    </para>
 
    <sect2>
@@ -3919,6 +4128,256 @@
    </sect2>
   </sect1>
 
+ <sect1 id="release-8-1-12">
+  <title>Release 8.1.12</title>
+
+  <note>
+  <title>Release date</title>
+  <simpara>2008-06-09</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 8.1.11.
+   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.12</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>
+      Fix <command>ALTER TABLE ADD COLUMN ... PRIMARY KEY</command> so that the new
+      column is correctly checked to see if it's been initialized to all
+      non-nulls (Brendan Jurd)
+     </para>
+
+     <para>
+      Previous versions neglected to check this requirement at all.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible <command>CREATE TABLE</command> failure when inheriting the
+      <quote>same</quote> constraint from multiple parent relations that
+      inherited that constraint from a common ancestor (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix conversions between ISO-8859-5 and other encodings to handle
+      Cyrillic <quote>Yo</quote> characters (<literal>e</literal> and <literal>E</literal> with
+      two dots) (Sergey Burladyan)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a few datatype input functions
+      that were allowing unused bytes in their results to contain
+      uninitialized, unpredictable values (Tom)
+     </para>
+
+     <para>
+      This could lead to failures in which two apparently identical literal
+      values were not seen as equal, resulting in the parser complaining
+      about unmatched <literal>ORDER BY</literal> and <literal>DISTINCT</literal>
+      expressions.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a corner case in regular-expression substring matching
+      (<literal>substring(<replaceable>string</replaceable> from
+      <replaceable>pattern</replaceable>)</literal>) (Tom)
+     </para>
+
+     <para>
+      The problem occurs when there is a match to the pattern overall but
+      the user has specified a parenthesized subexpression and that
+      subexpression hasn't got a match.  An example is
+      <literal>substring('foo' from 'foo(bar)?')</literal>.
+      This should return NULL, since <literal>(bar)</literal> isn't matched, but
+      it was mistakenly returning the whole-pattern match instead (ie,
+      <literal>foo</literal>).
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Update time zone data files to <application>tzdata</application> release 2008c (for
+      DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba,
+      Argentina/San_Luis, and Chile)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix incorrect result from <application>ecpg</application>'s
+      <function>PGTYPEStimestamp_sub()</function> function (Michael)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix core dump in <filename>contrib/xml2</filename>'s
+      <function>xpath_table()</function> function when the input query returns a
+      NULL value (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <filename>contrib/xml2</filename>'s makefile to not override
+      <literal>CFLAGS</literal> (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <literal>DatumGetBool</literal> macro to not fail with <application>gcc</application>
+      4.3 (Tom)
+     </para>
+
+     <para>
+      This problem affects <quote>old style</quote> (V0) C functions that
+      return boolean.  The fix is already in 8.3, but the need to
+      back-patch it was not realized at the time.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix longstanding <command>LISTEN</command>/<command>NOTIFY</command>
+      race condition (Tom)
+     </para>
+
+     <para>
+      In rare cases a session that had just executed a
+      <command>LISTEN</command> might not get a notification, even though
+      one would be expected because the concurrent transaction executing
+      <command>NOTIFY</command> was observed to commit later.
+     </para>
+
+     <para>
+      A side effect of the fix is that a transaction that has executed
+      a not-yet-committed <command>LISTEN</command> command will not see any
+      row in <structname>pg_listener</structname> for the <command>LISTEN</command>,
+      should it choose to look; formerly it would have.  This behavior
+      was never documented one way or the other, but it is possible that
+      some applications depend on the old behavior.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Disallow <command>LISTEN</command> and <command>UNLISTEN</command> within a
+      prepared transaction (Tom)
+     </para>
+
+     <para>
+      This was formerly allowed but trying to do it had various unpleasant
+      consequences, notably that the originating backend could not exit
+      as long as an <command>UNLISTEN</command> remained uncommitted.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix rare crash when an error occurs during a query using a hash index
+      (Heikki)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix input of datetime values for February 29 in years BC (Tom)
+     </para>
+
+     <para>
+      The former coding was mistaken about which years were leap years.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <quote>unrecognized node type</quote> error in some variants of
+      <command>ALTER OWNER</command> (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>pg_ctl</application> to correctly extract the postmaster's port
+      number from command-line options (Itagaki Takahiro, Tom)
+     </para>
+
+     <para>
+      Previously, <literal>pg_ctl start -w</literal> could try to contact the
+      postmaster on the wrong port, leading to bogus reports of startup
+      failure.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Use <option>-fwrapv</option> to defend against possible misoptimization
+      in recent <application>gcc</application> versions (Tom)
+     </para>
+
+     <para>
+      This is known to be necessary when building <productname>PostgreSQL</productname>
+      with <application>gcc</application> 4.3 or later.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix display of constant expressions in <literal>ORDER BY</literal>
+      and <literal>GROUP BY</literal> (Tom)
+     </para>
+
+     <para>
+      An explictly casted constant would be shown incorrectly.  This could
+      for example lead to corruption of a view definition during
+      dump and reload.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>libpq</application> to handle NOTICE messages correctly
+      during COPY OUT (Tom)
+     </para>
+
+     <para>
+      This failure has only been observed to occur when a user-defined
+      datatype's output routine issues a NOTICE, but there is no
+      guarantee it couldn't happen due to other causes.
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-8-1-11">
   <title>Version 8.1.11</title>
 
@@ -3930,6 +4389,8 @@
   <para>
    Cette version contient divers correctifs de la version 8.1.10,
    et inclut des corrections pour des failles de sécurité importantes.
+   For information about new features in the 8.1 major release, see
+   <xref linkend="release-8-1"/>.
   </para>
 
   <para>
@@ -4206,6 +4667,8 @@
 
    <para>
     Cette version contient divers correctifs de la version 8.1.9.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4336,6 +4799,8 @@
    <para>
     Cette version contient quelques corrections de la 8.1.8, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4428,6 +4893,8 @@
 
    <para>
     Cette version contient une correction de la 8.1.7.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4469,6 +4936,8 @@
    <para>
     Cette version contient quelques corrections de la 8.1.6, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4566,6 +5035,8 @@
 
    <para>
     Cette version contient quelques corrections de la 8.1.5.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4720,6 +5191,8 @@
 
    <para>
     Cette version contient quelques corrections de la 8.1.4.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4798,6 +5271,8 @@
    <para>
     Cette version contient quelques corrections de la 8.1.3 incluant des
     correctifs pour des problèmes de sécurité extrêmement sérieux.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -4960,6 +5435,8 @@
    <para>
     Cette version contient quelques corrections de la 8.1.2 et un très sérieux
     problème de sécurité.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -5087,6 +5564,8 @@
 
    <para>
     Cette version contient quelques corrections de la version 8.1.1.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -5196,6 +5675,8 @@
 
    <para>
     Cette version contient quelques corrections vers la 8.1.0.
+    For information about new features in the 8.1 major release, see
+    <xref linkend="release-8-1"/>.
    </para>
 
    <sect2>
@@ -7449,6 +7930,243 @@
    </sect2>
   </sect1>
 
+ <sect1 id="release-8-0-16">
+  <title>Release 8.0.16</title>
+
+  <note>
+  <title>Release date</title>
+  <simpara>2008-06-09</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 8.0.15.
+   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.16</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>
+      Fix <command>ALTER TABLE ADD COLUMN ... PRIMARY KEY</command> so that the new
+      column is correctly checked to see if it's been initialized to all
+      non-nulls (Brendan Jurd)
+     </para>
+
+     <para>
+      Previous versions neglected to check this requirement at all.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix possible <command>CREATE TABLE</command> failure when inheriting the
+      <quote>same</quote> constraint from multiple parent relations that
+      inherited that constraint from a common ancestor (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix conversions between ISO-8859-5 and other encodings to handle
+      Cyrillic <quote>Yo</quote> characters (<literal>e</literal> and <literal>E</literal> with
+      two dots) (Sergey Burladyan)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a few datatype input functions
+      that were allowing unused bytes in their results to contain
+      uninitialized, unpredictable values (Tom)
+     </para>
+
+     <para>
+      This could lead to failures in which two apparently identical literal
+      values were not seen as equal, resulting in the parser complaining
+      about unmatched <literal>ORDER BY</literal> and <literal>DISTINCT</literal>
+      expressions.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a corner case in regular-expression substring matching
+      (<literal>substring(<replaceable>string</replaceable> from
+      <replaceable>pattern</replaceable>)</literal>) (Tom)
+     </para>
+
+     <para>
+      The problem occurs when there is a match to the pattern overall but
+      the user has specified a parenthesized subexpression and that
+      subexpression hasn't got a match.  An example is
+      <literal>substring('foo' from 'foo(bar)?')</literal>.
+      This should return NULL, since <literal>(bar)</literal> isn't matched, but
+      it was mistakenly returning the whole-pattern match instead (ie,
+      <literal>foo</literal>).
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Update time zone data files to <application>tzdata</application> release 2008c (for
+      DST law changes in Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba,
+      Argentina/San_Luis, and Chile)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix incorrect result from <application>ecpg</application>'s
+      <function>PGTYPEStimestamp_sub()</function> function (Michael)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix core dump in <filename>contrib/xml2</filename>'s
+      <function>xpath_table()</function> function when the input query returns a
+      NULL value (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <filename>contrib/xml2</filename>'s makefile to not override
+      <literal>CFLAGS</literal> (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <literal>DatumGetBool</literal> macro to not fail with <application>gcc</application>
+      4.3 (Tom)
+     </para>
+
+     <para>
+      This problem affects <quote>old style</quote> (V0) C functions that
+      return boolean.  The fix is already in 8.3, but the need to
+      back-patch it was not realized at the time.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix longstanding <command>LISTEN</command>/<command>NOTIFY</command>
+      race condition (Tom)
+     </para>
+
+     <para>
+      In rare cases a session that had just executed a
+      <command>LISTEN</command> might not get a notification, even though
+      one would be expected because the concurrent transaction executing
+      <command>NOTIFY</command> was observed to commit later.
+     </para>
+
+     <para>
+      A side effect of the fix is that a transaction that has executed
+      a not-yet-committed <command>LISTEN</command> command will not see any
+      row in <structname>pg_listener</structname> for the <command>LISTEN</command>,
+      should it choose to look; formerly it would have.  This behavior
+      was never documented one way or the other, but it is possible that
+      some applications depend on the old behavior.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix rare crash when an error occurs during a query using a hash index
+      (Heikki)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix input of datetime values for February 29 in years BC (Tom)
+     </para>
+
+     <para>
+      The former coding was mistaken about which years were leap years.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <quote>unrecognized node type</quote> error in some variants of
+      <command>ALTER OWNER</command> (Tom)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>pg_ctl</application> to correctly extract the postmaster's port
+      number from command-line options (Itagaki Takahiro, Tom)
+     </para>
+
+     <para>
+      Previously, <literal>pg_ctl start -w</literal> could try to contact the
+      postmaster on the wrong port, leading to bogus reports of startup
+      failure.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Use <option>-fwrapv</option> to defend against possible misoptimization
+      in recent <application>gcc</application> versions (Tom)
+     </para>
+
+     <para>
+      This is known to be necessary when building <productname>PostgreSQL</productname>
+      with <application>gcc</application> 4.3 or later.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix display of constant expressions in <literal>ORDER BY</literal>
+      and <literal>GROUP BY</literal> (Tom)
+     </para>
+
+     <para>
+      An explictly casted constant would be shown incorrectly.  This could
+      for example lead to corruption of a view definition during
+      dump and reload.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>libpq</application> to handle NOTICE messages correctly
+      during COPY OUT (Tom)
+     </para>
+
+     <para>
+      This failure has only been observed to occur when a user-defined
+      datatype's output routine issues a NOTICE, but there is no
+      guarantee it couldn't happen due to other causes.
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-8-0-15">
   <title>Version 8.0.15</title>
 
@@ -11374,6 +12092,151 @@
   </sect2>
  </sect1>
 
+ <sect1 id="release-7-4-20">
+  <title>Release 7.4.20</title>
+
+  <note>
+  <title>Release date</title>
+  <simpara>2008-06-09</simpara>
+  </note>
+
+  <para>
+   This release contains a variety of fixes from 7.4.19.
+   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.20</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>
+      Fix conversions between ISO-8859-5 and other encodings to handle
+      Cyrillic <quote>Yo</quote> characters (<literal>e</literal> and <literal>E</literal> with
+      two dots) (Sergey Burladyan)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a few datatype input functions
+      that were allowing unused bytes in their results to contain
+      uninitialized, unpredictable values (Tom)
+     </para>
+
+     <para>
+      This could lead to failures in which two apparently identical literal
+      values were not seen as equal, resulting in the parser complaining
+      about unmatched <literal>ORDER BY</literal> and <literal>DISTINCT</literal>
+      expressions.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix a corner case in regular-expression substring matching
+      (<literal>substring(<replaceable>string</replaceable> from
+      <replaceable>pattern</replaceable>)</literal>) (Tom)
+     </para>
+
+     <para>
+      The problem occurs when there is a match to the pattern overall but
+      the user has specified a parenthesized subexpression and that
+      subexpression hasn't got a match.  An example is
+      <literal>substring('foo' from 'foo(bar)?')</literal>.
+      This should return NULL, since <literal>(bar)</literal> isn't matched, but
+      it was mistakenly returning the whole-pattern match instead (ie,
+      <literal>foo</literal>).
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix incorrect result from <application>ecpg</application>'s
+      <function>PGTYPEStimestamp_sub()</function> function (Michael)
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <literal>DatumGetBool</literal> macro to not fail with <application>gcc</application>
+      4.3 (Tom)
+     </para>
+
+     <para>
+      This problem affects <quote>old style</quote> (V0) C functions that
+      return boolean.  The fix is already in 8.3, but the need to
+      back-patch it was not realized at the time.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix longstanding <command>LISTEN</command>/<command>NOTIFY</command>
+      race condition (Tom)
+     </para>
+
+     <para>
+      In rare cases a session that had just executed a
+      <command>LISTEN</command> might not get a notification, even though
+      one would be expected because the concurrent transaction executing
+      <command>NOTIFY</command> was observed to commit later.
+     </para>
+
+     <para>
+      A side effect of the fix is that a transaction that has executed
+      a not-yet-committed <command>LISTEN</command> command will not see any
+      row in <structname>pg_listener</structname> for the <command>LISTEN</command>,
+      should it choose to look; formerly it would have.  This behavior
+      was never documented one way or the other, but it is possible that
+      some applications depend on the old behavior.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix display of constant expressions in <literal>ORDER BY</literal>
+      and <literal>GROUP BY</literal> (Tom)
+     </para>
+
+     <para>
+      An explictly casted constant would be shown incorrectly.  This could
+      for example lead to corruption of a view definition during
+      dump and reload.
+     </para>
+    </listitem>
+
+    <listitem>
+     <para>
+      Fix <application>libpq</application> to handle NOTICE messages correctly
+      during COPY OUT (Tom)
+     </para>
+
+     <para>
+      This failure has only been observed to occur when a user-defined
+      datatype's output routine issues a NOTICE, but there is no
+      guarantee it couldn't happen due to other causes.
+     </para>
+    </listitem>
+
+   </itemizedlist>
+
+  </sect2>
+ </sect1>
+
  <sect1 id="release-7-4-19">
   <title>Version 7.4.19</title>
 
@@ -11385,6 +12248,8 @@
   <para>
    Cette version contient divers correctifs de la version 7.4.18,
    et inclut des corrections pour des failles de sécurité importantes.
+   For information about new features in the 7.4 major release, see
+   <xref linkend="release-7-4"/>.
   </para>
 
   <sect2>
@@ -11550,6 +12415,8 @@
 
    <para>
     Cette version contient divers correctifs de la version 7.4.17.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -11631,6 +12498,8 @@
    <para>
     Cette version contient quelques corrections de la 7.4.16, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -11702,6 +12571,8 @@
    <para>
     Cette version contient quelques corrections de la 7.4.15, dont la
     correction d'une faille de sécurité.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -11771,6 +12642,8 @@
 
    <para>
     Cette version contient quelques corrections de la 7.4.14.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -11862,6 +12735,8 @@
 
    <para>
     Cette version contient quelques corrections de la 7.4.13.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -11909,6 +12784,8 @@
    <para>
     Cette version contient quelques corrections de la 7.4.12 incluant des
     correctifs pour des problèmes de sécurité extrêmement sérieux.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12017,6 +12894,8 @@
 
    <para>
     Cette version contient quelques corrections de la 7.4.11.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12079,6 +12958,8 @@
 
    <para>
     Cette version contient quelques corrections de la version 7.4.10.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12150,6 +13031,8 @@
 
    <para>
     Cette version contient quelques corrections sur la 7.4.9.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12203,6 +13086,8 @@
 
    <para>
     Cette version contient quelques corrections de la 7.4.8.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12277,6 +13162,8 @@
    <para>
     Cette version contient quelques corrections sur la 7.4.7, dont des
     correctifs sur des failles de sécurité.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12463,6 +13350,8 @@
    <para>
     Cette version contient une variété de corrections de la version 7.4.6,
     incluant des correctifs de sécurité.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
    <sect2>
@@ -12525,6 +13414,8 @@
 
    <para>
     Cette version contient plusieurs correctifs de la version 7.4.5.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 
@@ -12608,6 +13499,8 @@
 
    <para>
     Cette version contient la correction d'un bogue sérieux de la version 7.4.4.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 
@@ -12647,6 +13540,8 @@
 
    <para>
     Cette version contient quelques correctifs sur la 7.4.3.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 
@@ -12708,6 +13603,8 @@
 
    <para>
     Cette version contient quelques correctifs pour la 7.4.2.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 
@@ -12782,6 +13679,8 @@
 
    <para>
     Cette version contient quelques correctifs pour la 7.4.1.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 
@@ -12936,6 +13835,8 @@
 
    <para>
     Cette version contient plusieurs correctifs de la 7.4.
+    For information about new features in the 7.4 major release, see
+    <xref linkend="release-7-4"/>.
    </para>
 
 

Modified: traduc/branches/bv82x/manuel/version.xml
===================================================================
--- traduc/branches/bv82x/manuel/version.xml	2008-06-06 12:59:58 UTC (rev 1056)
+++ traduc/branches/bv82x/manuel/version.xml	2008-06-06 13:15:56 UTC (rev 1057)
@@ -1,2 +1,2 @@
-<!ENTITY version "8.2.7">
+<!ENTITY version "8.2.8">
 <!ENTITY majorversion "8.2">



More information about the Trad mailing list