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 $ -->
2
2
<!--
3
3
4
4
Typical markup:
@@ -177,18 +177,6 @@ links to the main documentation.
177
177
</para>
178
178
</listitem>
179
179
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
-
192
180
<listitem>
193
181
<para>
194
182
Change the <link linkend="sql-syntax-row-constructors">row
@@ -2372,7 +2360,7 @@ links to the main documentation.
2372
2360
2373
2361
<note>
2374
2362
<title>Release date</title>
2375
- <simpara>2006-10-?? </simpara>
2363
+ <simpara>2006-10-16 </simpara>
2376
2364
</note>
2377
2365
2378
2366
<para>
@@ -2394,37 +2382,46 @@ links to the main documentation.
2394
2382
<title>Changes</title>
2395
2383
2396
2384
<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>
2411
2395
<listitem><para>Fix <command>ALTER TABLE ... TYPE</> to recheck
2412
2396
<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>
2416
2417
<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>
2420
2423
<listitem><para>Fixes for <systemitem class="osname">AIX</> and
2421
2424
<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
-
2428
2425
</itemizedlist>
2429
2426
2430
2427
</sect2>
@@ -5020,7 +5017,7 @@ psql -t -f fixseq.sql db1 | psql -e db1
5020
5017
5021
5018
<note>
5022
5019
<title>Release date</title>
5023
- <simpara>2006-10-?? </simpara>
5020
+ <simpara>2006-10-16 </simpara>
5024
5021
</note>
5025
5022
5026
5023
<para>
@@ -5042,23 +5039,26 @@ psql -t -f fixseq.sql db1 | psql -e db1
5042
5039
<title>Changes</title>
5043
5040
5044
5041
<itemizedlist>
5045
-
5046
5042
<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>
5050
5046
<listitem><para>Fix <command>ALTER TABLE ... TYPE</> to recheck
5051
5047
<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>
5054
5060
<listitem><para>Fixes for <systemitem class="osname">AIX</> and
5055
5061
<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
-
5062
5062
</itemizedlist>
5063
5063
5064
5064
</sect2>
@@ -8222,7 +8222,7 @@ typedefs (Michael)</para></listitem>
8222
8222
8223
8223
<note>
8224
8224
<title>Release date</title>
8225
- <simpara>2006-10-?? </simpara>
8225
+ <simpara>2006-10-16 </simpara>
8226
8226
</note>
8227
8227
8228
8228
<para>
@@ -8244,14 +8244,19 @@ typedefs (Michael)</para></listitem>
8244
8244
<title>Changes</title>
8245
8245
8246
8246
<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>
8251
8249
<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>
8255
8260
</itemizedlist>
8256
8261
8257
8262
</sect2>
@@ -11176,7 +11181,7 @@ DROP SCHEMA information_schema CASCADE;
11176
11181
11177
11182
<note>
11178
11183
<title>Release date</title>
11179
- <simpara>2006-10-?? </simpara>
11184
+ <simpara>2006-10-16 </simpara>
11180
11185
</note>
11181
11186
11182
11187
<para>
@@ -11198,10 +11203,16 @@ DROP SCHEMA information_schema CASCADE;
11198
11203
<title>Changes</title>
11199
11204
11200
11205
<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>
11205
11216
</itemizedlist>
11206
11217
11207
11218
</sect2>