1- <!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.470 2006/10/09 23:23:47 momjian Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.471 2006/10/11 20:55:52 tgl Exp $ -->
22<!--
33
44Typical markup:
@@ -177,18 +177,6 @@ links to the main documentation.
177177 </para>
178178 </listitem>
179179
180- <listitem>
181- <para>
182- Disallow aggregate functions in <command>UPDATE</> commands
183- (unless within a subquery) (Tom)
184- </para>
185-
186- <para>
187- The standard disallows this, and it leads to unpredictable
188- results.
189- </para>
190- </listitem>
191-
192180 <listitem>
193181 <para>
194182 Change the <link linkend="sql-syntax-row-constructors">row
@@ -2372,7 +2360,7 @@ links to the main documentation.
23722360
23732361 <note>
23742362 <title>Release date</title>
2375- <simpara>2006-10-?? </simpara>
2363+ <simpara>2006-10-16 </simpara>
23762364 </note>
23772365
23782366 <para>
@@ -2394,37 +2382,46 @@ links to the main documentation.
23942382 <title>Changes</title>
23952383
23962384<itemizedlist>
2397-
2398- <listitem><para>Fix for <systemitem class="osname">OS/X</>
2399- <application>Bonjour</> on x86 systems (Ashley Clark)</para></listitem>
2400- <listitem><para>Fix <acronym>MSVC</>/<productname>Borland C++</>
2401- compiles (Hiroshi Saito)</para></listitem>
2402- <listitem><para>Minor fixes related to ecpg, /contrib/dblink,
2403- /contrib/ltree, /contrib/tsearch2, and <application>psql</></para> </listitem>
2404- <listitem><para>Add ability to log protocol-level prepared
2405- statements (Tom)</para></listitem>
2406- <listitem><para>Disallow non-subselect aggregates in <command>UPDATE</>
2407- statements (Tom)</para>
2408- <para>The behavior of such an aggregate was unpredictable,
2409- so it has been disabled. The SQL standard does not support
2410- it either.</para></listitem>
2385+ <listitem><para>Disallow aggregate functions in <command>UPDATE</>
2386+ commands, except within sub-SELECTs (Tom)</para>
2387+ <para>The behavior of such an aggregate was unpredictable, and in 8.1.X
2388+ could cause a crash, so it has been disabled. The SQL standard does not allow
2389+ this either.</para></listitem>
2390+ <listitem><para>Fix core dump when an untyped literal is taken as
2391+ ANYARRAY</para></listitem>
2392+ <listitem><para>Fix core dump in duration logging for extended query protocol
2393+ when a <command>COMMIT</> or <command>ROLLBACK</> is
2394+ executed</para></listitem>
24112395<listitem><para>Fix <command>ALTER TABLE ... TYPE</> to recheck
24122396<literal>NOT NULL</> for <literal>USING</> clause (Tom)</para></listitem>
2413- <listitem><para>Fix rare termination of the statistics collector
2414- process on Win32 (Tom)</para></listitem>
2415- <listitem><para>Improvements to hash and bitmap joins (Tom)</para></listitem>
2397+ <listitem><para>Fix <function>string_to_array()</> to handle overlapping
2398+ matches for the separator string</para>
2399+ <para>For example, <literal>string_to_array('123xx456xxx789', 'xx')</>.
2400+ </para></listitem>
2401+ <listitem><para>Fix <function>to_timestamp()</> for
2402+ <literal>AM</>/<literal>PM</> formats (Bruce)</para></listitem>
2403+ <listitem><para>Fix autovacuum's calculation that decides whether
2404+ <command>ANALYZE</> is needed (Alvaro)</para></listitem>
2405+ <listitem><para>Fix corner cases in pattern matching for
2406+ <application>psql</>'s <literal>\d</> commands</para></listitem>
2407+ <listitem><para>Fix index-corrupting bugs in /contrib/ltree
2408+ (Teodor)</para></listitem>
2409+ <listitem><para>Numerous robustness fixes in <application>ecpg</> (Joachim
2410+ Wieland)</para></listitem>
2411+ <listitem><para>Fix backslash escaping in /contrib/dbmirror</para></listitem>
2412+ <listitem><para>Minor fixes in /contrib/dblink and /contrib/tsearch2</para>
2413+ </listitem>
2414+ <listitem><para>Efficiency improvements in hash tables and bitmap index scans
2415+ (Tom)</para></listitem>
2416+ <listitem><para>Fix instability of statistics collection on Win32 (Tom, Andrew)</para></listitem>
24162417<listitem><para>Fix <varname>statement_timeout</> to use the proper
2417- units of microseconds on Win32 (Bruce)</para>
2418- <para>In previous Win32 8.1.X versions, 100-microseconds units were
2419- incorrectly used internally.</para></listitem>
2418+ units on Win32 (Bruce)</para>
2419+ <para>In previous Win32 8.1.X versions, the delay was off by a factor of
2420+ 100.</para></listitem>
2421+ <listitem><para>Fixes for <acronym>MSVC</> and <productname>Borland C++</>
2422+ compilers (Hiroshi Saito)</para></listitem>
24202423<listitem><para>Fixes for <systemitem class="osname">AIX</> and
24212424<productname>Intel</> compilers (Tom)</para></listitem>
2422- <listitem><para>Fix <function>to_timestamp()</> for
2423- <literal>PM</>/<literal>AM</> (Bruce)</para></listitem>
2424- <listitem><para>Fix <function>string_to_array()</> to handle overlapping
2425- matches for the separator string</para> <para>For example,
2426- <literal>string_to_array('123xx456xxx789', 'xx')</>.</para></listitem>
2427-
24282425</itemizedlist>
24292426
24302427 </sect2>
@@ -5020,7 +5017,7 @@ psql -t -f fixseq.sql db1 | psql -e db1
50205017
50215018 <note>
50225019 <title>Release date</title>
5023- <simpara>2006-10-?? </simpara>
5020+ <simpara>2006-10-16 </simpara>
50245021 </note>
50255022
50265023 <para>
@@ -5042,23 +5039,26 @@ psql -t -f fixseq.sql db1 | psql -e db1
50425039 <title>Changes</title>
50435040
50445041<itemizedlist>
5045-
50465042<listitem><para>Fix crash when referencing <literal>NEW</> row
5047- values inrules (Tom)</para></listitem>
5048- <listitem><para>Add ability to log protocol-level prepared
5049- statements (Tom) </para></listitem>
5043+ values inrule WHERE expressions (Tom)</para></listitem>
5044+ <listitem><para>Fix core dump when an untyped literal is taken as
5045+ ANYARRAY </para></listitem>
50505046<listitem><para>Fix <command>ALTER TABLE ... TYPE</> to recheck
50515047<literal>NOT NULL</> for <literal>USING</> clause (Tom)</para></listitem>
5052- <listitem><para>Fix rare termination of the statistics collector
5053- process on Win32 (Tom)</para></listitem>
5048+ <listitem><para>Fix <function>string_to_array()</> to handle overlapping
5049+ matches for the separator string</para>
5050+ <para>For example, <literal>string_to_array('123xx456xxx789', 'xx')</>.
5051+ </para></listitem>
5052+ <listitem><para>Fix corner cases in pattern matching for
5053+ <application>psql</>'s <literal>\d</> commands</para></listitem>
5054+ <listitem><para>Fix index-corrupting bugs in /contrib/ltree
5055+ (Teodor)</para></listitem>
5056+ <listitem><para>Numerous robustness fixes in <application>ecpg</> (Joachim
5057+ Wieland)</para></listitem>
5058+ <listitem><para>Fix backslash escaping in /contrib/dbmirror</para></listitem>
5059+ <listitem><para>Fix instability of statistics collection on Win32 (Tom, Andrew)</para></listitem>
50545060<listitem><para>Fixes for <systemitem class="osname">AIX</> and
50555061<productname>Intel</> compilers (Tom)</para></listitem>
5056- <listitem><para>Fix <function>string_to_array()</> to handle overlapping
5057- matches for the separator string</para> <para>For example,
5058- <literal>string_to_array('123xx456xxx789', 'xx')</>.</para></listitem>
5059- <listitem><para>Minor fixes related to ecpg, /contrib/ltree,
5060- and <application>psql</></para> </listitem>
5061-
50625062</itemizedlist>
50635063
50645064 </sect2>
@@ -8222,7 +8222,7 @@ typedefs (Michael)</para></listitem>
82228222
82238223 <note>
82248224 <title>Release date</title>
8225- <simpara>2006-10-?? </simpara>
8225+ <simpara>2006-10-16 </simpara>
82268226 </note>
82278227
82288228 <para>
@@ -8244,14 +8244,19 @@ typedefs (Michael)</para></listitem>
82448244 <title>Changes</title>
82458245
82468246<itemizedlist>
8247-
8248- <listitem><para>Minor fixes related to timezones, ecpg, /contrib/ltree,
8249- and <application>psql</></para> </listitem>
8250-
8247+ <listitem><para>Fix core dump when an untyped literal is taken as
8248+ ANYARRAY</para></listitem>
82518249<listitem><para>Fix <function>string_to_array()</> to handle overlapping
8252- matches for the separator string</para> <para>For example,
8253- <literal>string_to_array('123xx456xxx789', 'xx')</>.</para></listitem>
8254-
8250+ matches for the separator string</para>
8251+ <para>For example, <literal>string_to_array('123xx456xxx789', 'xx')</>.
8252+ </para></listitem>
8253+ <listitem><para>Fix corner cases in pattern matching for
8254+ <application>psql</>'s <literal>\d</> commands</para></listitem>
8255+ <listitem><para>Fix index-corrupting bugs in /contrib/ltree
8256+ (Teodor)</para></listitem>
8257+ <listitem><para>Fix backslash escaping in /contrib/dbmirror</para></listitem>
8258+ <listitem><para>Adjust regression tests for recent changes in US DST laws
8259+ </para> </listitem>
82558260</itemizedlist>
82568261
82578262 </sect2>
@@ -11176,7 +11181,7 @@ DROP SCHEMA information_schema CASCADE;
1117611181
1117711182 <note>
1117811183 <title>Release date</title>
11179- <simpara>2006-10-?? </simpara>
11184+ <simpara>2006-10-16 </simpara>
1118011185 </note>
1118111186
1118211187 <para>
@@ -11198,10 +11203,16 @@ DROP SCHEMA information_schema CASCADE;
1119811203 <title>Changes</title>
1119911204
1120011205<itemizedlist>
11201-
11202- <listitem><para>Minor fixes related to timezones, spinlocks, SSL,
11203- GiST, /contrib/ltree, and <application>psql</></para> </listitem>
11204-
11206+ <listitem><para>Fix corner cases in pattern matching for
11207+ <application>psql</>'s <literal>\d</> commands</para></listitem>
11208+ <listitem><para>Fix index-corrupting bugs in /contrib/ltree
11209+ (Teodor)</para></listitem>
11210+ <listitem><para>Back-port 7.4 spinlock code to improve performance and support
11211+ 64-bit architectures better</para> </listitem>
11212+ <listitem><para>Fix SSL-related memory leak in libpq</para> </listitem>
11213+ <listitem><para>Fix backslash escaping in /contrib/dbmirror</para></listitem>
11214+ <listitem><para>Adjust regression tests for recent changes in US DST laws
11215+ </para> </listitem>
1120511216</itemizedlist>
1120611217
1120711218 </sect2>