11<!--
2- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.416 2006/01/05 15:19:05 momjian Exp $
2+ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.417 2006/01/06 02:59:57 tgl Exp $
33
44Typical markup:
55
@@ -10,7 +10,7 @@ PostgreSQL <productname>
1010pg_[A-Za-z0-9_] <application>
1111[A-Z][A-Z] <type>, <envar>, <literal>
1212&<> use &
13- non-ascii convert to & escapes
13+ non-ascii convert to & escapes
1414
1515For new features, add links to the documentation sections.
1616
@@ -36,6 +36,9 @@ For new features, add links to the documentation sections.
3636
3737 <para>
3838 A dump/restore is not required for those running 8.1.X.
39+ However, you might need to <command>REINDEX</> indexes on textual
40+ columns after updating, if you are affected by the locale or
41+ <application>plperl</> issues described below.
3942 </para>
4043 </sect2>
4144
@@ -44,57 +47,73 @@ For new features, add links to the documentation sections.
4447
4548<itemizedlist>
4649
47- <listitem><para>Fix for protocol-level describe portal statements issued
48- outside a transaction (Tom)</para></listitem>
49-
50- <listitem><para>Fix character set sorting for locales that consider
51- different character combinations to have the same sorting, e.g.
52- Hungarian. (Tom) </para><para>This might require <command>REINDEX</> in
53- those locales to fix existing indexes.</para></listitem>
50+ <listitem><para>Fix Windows code so that postmaster will continue rather
51+ than exit if there is no more room in ShmemBackendArray (Magnus)</para>
52+ <para>The previous behavior could lead to a denial-of-service situation if too
53+ many connection requests arrive close together. This applies
54+ <emphasis>only</> to the Windows port.</para></listitem>
55+
56+ <listitem><para>Fix bug introduced in 8.0 that could allow ReadBuffer
57+ to return an already-used page as new, potentially causing loss of
58+ recently-committed data (Tom)</para></listitem>
59+
60+ <listitem><para>Fix for protocol-level Describe messages issued
61+ outside a transaction or in a failed transaction (Tom)</para></listitem>
62+
63+ <listitem><para>Fix character string comparison for locales that consider
64+ different character combinations as equal, such as Hungarian (Tom)</para>
65+ <para>This might require <command>REINDEX</> to fix existing indexes on
66+ textual columns.</para></listitem>
67+
68+ <listitem><para>Set locale environment variables during postmaster startup
69+ to ensure that <application>plperl</> won't change the locale later</para>
70+ <para>This fixes a problem that occurred if the <application>postmaster</> was
71+ started with environment variables specifying a different locale than what
72+ <application>initdb</> had been told. Under these conditions, any use of
73+ <application>plperl</> was likely to lead to corrupt indexes. You may need
74+ <command>REINDEX</> to fix existing indexes on
75+ textual columns if this has happened to you.</para></listitem>
5476
5577<listitem><para>Allow more flexible relocation of installation
56- directories (Tom)</para> <para>Previous releases supported relocation
57- only if all directories were the same except the last
58- component.</para></listitem>
78+ directories (Tom)</para>
79+ <para>Previous releases supported relocation only if all installation
80+ directory paths were the same except for the last component.</para></listitem>
5981
60- <listitem><para>Preventcrashed caused by the use of
82+ <listitem><para>Preventcrashes caused by the use of
6183<literal>ISO-8859-5</> and <literal>ISO-8859-9</> encodings
6284(Tatsuo)</para></listitem>
6385
64- <listitem><para>Fix bug in strpos() and regular expression handling in
65- certain rarely used Asian multi-byte character sets (Tatsuo)
86+ <listitem><para>Fixlongstanding bug in strpos() and regular expression
87+ handling in certain rarely used Asian multi-byte character sets (Tatsuo)
6688</para></listitem>
6789
6890<listitem><para>Fix bug where COPY CSV mode considered any
6991<literal>\.</> to terminate the copy data</para> <para>The new code
70- requires <literal>\.</> to appear alone on a line, aspreviously
71- documented .</para></listitem>
92+ requires <literal>\.</> to appear alone on a line, asper
93+ documentation .</para></listitem>
7294
73- <listitem><para>Have COPYoutput a literal data value of <literal>\.</>
74- in double-quotes toprevent itfrom being interpreted as the end-of-data
75- marker (Bruce)</para></listitem>
95+ <listitem><para>Make COPYCSV mode quote a literal data value of
96+ <literal>\.</> toensure itcannot be interpreted as the
97+ end-of-data marker (Bruce)</para></listitem>
7698
77- <listitem><para>Various fixes forqueries returning <literal>RECORD</>s
99+ <listitem><para>Various fixes forfunctions returning <literal>RECORD</>s
78100(Tom) </para></listitem>
79101
80102<listitem><para>Fix processing of <filename>postgresql.conf</> so a
81103final line with no newline is processed properly (Tom)
82104</para></listitem>
83105
84106<listitem><para>Fix bug in <filename>/contrib/pgcrypto</> gen_salt,
85- which caused it not to use all available salt space formd5 and
86- xdes algorithms (Marko Kreen, Solar Designer)</para>
87- <para>Salts forblowfish and standarddes are unaffected</para></listitem>
107+ which caused it not to use all available salt space forMD5 and
108+ XDES algorithms (Marko Kreen, Solar Designer)</para>
109+ <para>Salts forBlowfish and standardDES are unaffected. </para></listitem>
88110
89111<listitem><para>Fix autovacuum crash when processing expression indexes
90112</para></listitem>
91113
92- <listitem><para>Fix <filename>/contrib/dblink</> to throw an error
93- when the number of columns specified is different from those returned
94- by the query (Joe)</para></listitem>
95-
96- <listitem><para>Set <literal>LC_XXX</> variables to prevent problems
97- with <application>plperl</> processing (Tom)</para></listitem>
114+ <listitem><para>Fix <filename>/contrib/dblink</> to throw an error,
115+ rather than crashing, when the number of columns specified is different from
116+ what's actually returned by the query (Joe)</para></listitem>
98117
99118</itemizedlist>
100119
@@ -2332,6 +2351,9 @@ psql -t -f fixseq.sql db1 | psql -e db1
23322351 A dump/restore is not required for those running 8.0.X. However,
23332352 if you are upgrading from a version earlier than 8.0.3, see the release
23342353 notes for 8.0.3.
2354+ Also, you might need to <command>REINDEX</> indexes on textual
2355+ columns after updating, if you are affected by the locale or
2356+ <application>plperl</> issues described below.
23352357 </para>
23362358 </sect2>
23372359
@@ -2340,34 +2362,53 @@ psql -t -f fixseq.sql db1 | psql -e db1
23402362
23412363<itemizedlist>
23422364
2343- <listitem><para>Fix for protocol-level describe portal statements issued
2344- outside a transaction (Tom)</para></listitem>
2345-
2346- <listitem><para>Fix character set sorting for locales that consider
2347- different character combinations to have the same sorting, e.g.
2348- Hungarian. (Tom) </para><para>This might require <command>REINDEX</> in
2349- those locales to fix existing indexes.</para></listitem>
2365+ <listitem><para>Fix Windows code so that postmaster will continue rather
2366+ than exit if there is no more room in ShmemBackendArray (Magnus)</para>
2367+ <para>The previous behavior could lead to a denial-of-service situation if too
2368+ many connection requests arrive close together. This applies
2369+ <emphasis>only</> to the Windows port.</para></listitem>
2370+
2371+ <listitem><para>Fix bug introduced in 8.0 that could allow ReadBuffer
2372+ to return an already-used page as new, potentially causing loss of
2373+ recently-committed data (Tom)</para></listitem>
2374+
2375+ <listitem><para>Fix for protocol-level Describe messages issued
2376+ outside a transaction or in a failed transaction (Tom)</para></listitem>
2377+
2378+ <listitem><para>Fix character string comparison for locales that consider
2379+ different character combinations as equal, such as Hungarian (Tom)</para>
2380+ <para>This might require <command>REINDEX</> to fix existing indexes on
2381+ textual columns.</para></listitem>
2382+
2383+ <listitem><para>Set locale environment variables during postmaster startup
2384+ to ensure that <application>plperl</> won't change the locale later</para>
2385+ <para>This fixes a problem that occurred if the <application>postmaster</> was
2386+ started with environment variables specifying a different locale than what
2387+ <application>initdb</> had been told. Under these conditions, any use of
2388+ <application>plperl</> was likely to lead to corrupt indexes. You may need
2389+ <command>REINDEX</> to fix existing indexes on
2390+ textual columns if this has happened to you.</para></listitem>
23502391
23512392<listitem><para>Allow more flexible relocation of installation
2352- directories (Tom)</para> <para>Previous releases supported relocation
2353- only if all directories were the same except the last
2354- componient .</para></listitem>
2393+ directories (Tom)</para>
2394+ <para>Previous releases supported relocation only if all installation
2395+ directory paths were the same except for the last component .</para></listitem>
23552396
2356- <listitem><para>Fix long standing Asian multibyte charsets bug (Tatsuo)
2397+ <listitem><para>Fix longstanding bug in strpos() and regular expression
2398+ handling in certain rarely used Asian multi-byte character sets (Tatsuo)
23572399</para></listitem>
23582400
2359- <listitem><para>Various fixes forqueries returning <literal>RECORD</>s
2401+ <listitem><para>Various fixes forfunctions returning <literal>RECORD</>s
23602402(Tom) </para></listitem>
23612403
2362- <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> Openwall
2363- gen_salt processing (Marko Kreen></para></listitem>
2364-
2365- <listitem><para>Fix <filename>/contrib/dblink</> to throw an error
2366- when the number of columns specified is different from those returned
2367- by the query (Joe)</para></listitem>
2404+ <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> gen_salt,
2405+ which caused it not to use all available salt space for MD5 and
2406+ XDES algorithms (Marko Kreen, Solar Designer)</para>
2407+ <para>Salts for Blowfish and standard DES are unaffected.</para></listitem>
23682408
2369- <listitem><para>Set <literal>LC_XXX</> variables to prevent problems
2370- with <application>plperl</> processing (Tom)</para></listitem>
2409+ <listitem><para>Fix <filename>/contrib/dblink</> to throw an error,
2410+ rather than crashing, when the number of columns specified is different from
2411+ what's actually returned by the query (Joe)</para></listitem>
23712412
23722413</itemizedlist>
23732414
@@ -5254,6 +5295,9 @@ typedefs (Michael)</para></listitem>
52545295 A dump/restore is not required for those running 7.4.X. However,
52555296 if you are upgrading from a version earlier than 7.4.8, see the release
52565297 notes for 7.4.8.
5298+ Also, you might need to <command>REINDEX</> indexes on textual
5299+ columns after updating, if you are affected by the locale or
5300+ <application>plperl</> issues described below.
52575301 </para>
52585302 </sect2>
52595303
@@ -5262,26 +5306,35 @@ typedefs (Michael)</para></listitem>
52625306
52635307<itemizedlist>
52645308
5265- <listitem><para>Fix for protocol-level describe portal statements issued
5266- outside a transaction (Tom)</para></listitem>
5267-
5268- <listitem><para>Fix character set sorting for locales that consider
5269- different character combinations to have the same sorting, e.g.
5270- Hungarian. (Tom) </para><para>This might require <command>REINDEX</> in
5271- those locales to fix existing indexes.</para></listitem>
5272-
5273- <listitem><para>Fix long standing Asian multibyte charsets bug (Tatsuo)
5309+ <listitem><para>Fix for protocol-level Describe messages issued
5310+ outside a transaction or in a failed transaction (Tom)</para></listitem>
5311+
5312+ <listitem><para>Fix character string comparison for locales that consider
5313+ different character combinations as equal, such as Hungarian (Tom)</para>
5314+ <para>This might require <command>REINDEX</> to fix existing indexes on
5315+ textual columns.</para></listitem>
5316+
5317+ <listitem><para>Set locale environment variables during postmaster startup
5318+ to ensure that <application>plperl</> won't change the locale later</para>
5319+ <para>This fixes a problem that occurred if the <application>postmaster</> was
5320+ started with environment variables specifying a different locale than what
5321+ <application>initdb</> had been told. Under these conditions, any use of
5322+ <application>plperl</> was likely to lead to corrupt indexes. You may need
5323+ <command>REINDEX</> to fix existing indexes on
5324+ textual columns if this has happened to you.</para></listitem>
5325+
5326+ <listitem><para>Fix longstanding bug in strpos() and regular expression
5327+ handling in certain rarely used Asian multi-byte character sets (Tatsuo)
52745328</para></listitem>
52755329
5276- <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> Openwall
5277- gen_salt processing (Marko Kreen></para></listitem>
5278-
5279- <listitem><para>Fix <filename>/contrib/dblink</> to throw an error
5280- when the number of columns specified is different from those returned
5281- by the query (Joe)</para></listitem>
5330+ <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> gen_salt,
5331+ which caused it not to use all available salt space for MD5 and
5332+ XDES algorithms (Marko Kreen, Solar Designer)</para>
5333+ <para>Salts for Blowfish and standard DES are unaffected.</para></listitem>
52825334
5283- <listitem><para>Set <literal>LC_XXX</> variables to prevent problems
5284- with <application>plperl</> processing (Tom)</para></listitem>
5335+ <listitem><para>Fix <filename>/contrib/dblink</> to throw an error,
5336+ rather than crashing, when the number of columns specified is different from
5337+ what's actually returned by the query (Joe)</para></listitem>
52855338
52865339</itemizedlist>
52875340
@@ -7990,6 +8043,9 @@ DROP SCHEMA information_schema CASCADE;
79908043 A dump/restore is not required for those running 7.3.X. However,
79918044 if you are upgrading from a version earlier than 7.3.10, see the release
79928045 notes for 7.3.10.
8046+ Also, you might need to <command>REINDEX</> indexes on textual
8047+ columns after updating, if you are affected by the locale or
8048+ <application>plperl</> issues described below.
79938049 </para>
79948050 </sect2>
79958051
@@ -7998,23 +8054,32 @@ DROP SCHEMA information_schema CASCADE;
79988054
79998055<itemizedlist>
80008056
8001- <listitem><para>Fix character set sorting for locales that consider
8002- different character combinations to have the same sorting, e.g.
8003- Hungarian. (Tom) </para><para>This might require <command>REINDEX</> in
8004- those locales to fix existing indexes.</para></listitem>
8005-
8006- <listitem><para>Fix long standing Asian multibyte charsets bug (Tatsuo)
8057+ <listitem><para>Fix character string comparison for locales that consider
8058+ different character combinations as equal, such as Hungarian (Tom)</para>
8059+ <para>This might require <command>REINDEX</> to fix existing indexes on
8060+ textual columns.</para></listitem>
8061+
8062+ <listitem><para>Set locale environment variables during postmaster startup
8063+ to ensure that <application>plperl</> won't change the locale later</para>
8064+ <para>This fixes a problem that occurred if the <application>postmaster</> was
8065+ started with environment variables specifying a different locale than what
8066+ <application>initdb</> had been told. Under these conditions, any use of
8067+ <application>plperl</> was likely to lead to corrupt indexes. You may need
8068+ <command>REINDEX</> to fix existing indexes on
8069+ textual columns if this has happened to you.</para></listitem>
8070+
8071+ <listitem><para>Fix longstanding bug in strpos() and regular expression
8072+ handling in certain rarely used Asian multi-byte character sets (Tatsuo)
80078073</para></listitem>
80088074
8009- <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> Openwall
8010- gen_salt processing (Marko Kreen></para></listitem>
8011-
8012- <listitem><para>Fix <filename>/contrib/dblink</> to throw an error
8013- when the number of columns specified is different from those returned
8014- by the query (Joe)</para></listitem>
8075+ <listitem><para>Fix bug in <filename>/contrib/pgcrypto</> gen_salt,
8076+ which caused it not to use all available salt space for MD5 and
8077+ XDES algorithms (Marko Kreen, Solar Designer)</para>
8078+ <para>Salts for Blowfish and standard DES are unaffected.</para></listitem>
80158079
8016- <listitem><para>Set <literal>LC_XXX</> variables to prevent problems
8017- with <application>plperl</> processing (Tom)</para></listitem>
8080+ <listitem><para>Fix <filename>/contrib/dblink</> to throw an error,
8081+ rather than crashing, when the number of columns specified is different from
8082+ what's actually returned by the query (Joe)</para></listitem>
80188083
80198084</itemizedlist>
80208085