From 26f831a95058d928c83453a37456a0fa32d10cae Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 7 Apr 2005 19:04:13 +0000 Subject: [PATCH] Update and copy-edit release notes for 8.0.2. --- doc/src/sgml/release.sgml | 177 +++++++++++++++++++++++++++------------------- 1 file changed, 105 insertions(+), 72 deletions(-) diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 4fee54a98c..d2a2111d18 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ @@ -22,8 +22,8 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.332 2005/04/05 04:47:19 tgl Exp A dump/restore is not required for those running 8.0.*. - This release does update the major version number of the - PostgreSQL libraries so it might be + This release updates the major version number of the + PostgreSQL libraries, so it might be necessary to re-link some user applications if they cannot find the properly-numbered shared library. @@ -33,42 +33,6 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.332 2005/04/05 04:47:19 tgl Exp Changes -Use the proper default mask length for INET data types with class - D addresses (Tom) -Allow plpgsql to assign a value to an array that is initially - NULL (Tom) -Fix CLUSTER failure after ALTER TABLE - SET WITHOUT OIDS (Tom) -Fix ecpg bugs in parsing of CREATE statement - (Michael) -Reduce memory usage of ALTER TABLE ADD COLUMN - (Neil) -Allow SPI to handle utility commands like EXPLAIN - that return rows (Tom) -Fix ALTER LANGUAGE RENAME (Tom) -Document the Win32 register and - unregister - pg_ctl options (Magnus) -Several /contrib/btree_gist fixes (Teodor) - -New cache replacement policy 2Q replaces - ARC (Tom) - - This was done to void a pending US patent on ARC. The - 2Q code might be a few percentage points slower than - ARC for busy sites. Another new cache replacement - policy will appear in 8.1. - -Change the Win32 default for config variable - log_destination to - - This, by default, will send all Win32 server log output to the Win32 event - logger rather than standard error. - -Fix crash of some /contrib/pgcrypto - functions on some platforms (Neil) -Allow ALTER DATABASE RENAME by superusers - who can't create databases (Tom) Increment the major version number of all interface libraries (Bruce) @@ -77,51 +41,120 @@ $PostgreSQL: pgsql/doc/src/sgml/release.sgml,v 1.332 2005/04/05 04:47:19 tgl Exp can be used on the same machine as 8.0.X applications. This might require re-linking user applications that use these libraries. -Do not use locale-aware versions of upper(), - lower(), and initcap() when the locale is C. - (Bruce) +Add Windows-only wal_sync_method setting of + + + This setting causes PostgreSQL to write through + any disk-drive write cache when writing to WAL. + This behavior was formerly called + +Enable the wal_sync_method setting of + + + Because the default is no longer + +New cache management algorithm 2Q replaces + ARC (Tom) + + This was done to avoid a pending US patent on ARC. The + 2Q code might be a few percentage points slower than + ARC for some work loads. A better cache management algorithm + will appear in 8.1. + +Planner adjustments to improve behavior on freshly-created +tables (Tom) +Allow plpgsql to assign to an element of an array that is +initially NULL (Tom) + + Formerly the array would remain NULL, but now it becomes a + single-element array. The main SQL engine was changed to handle + UPDATE of a null array value this way in 8.0, but the similar + case in plpgsql was overlooked. + + +Convert \r\n and \r to \n +in plpython function bodies (Michael Fuhr) - This allows these functions to work on platforms that sometimes - generate errors with a locale of C and a non-SQL_ASCII - encoding. + This prevents syntax errors when plpython code is written on a Windows or + Mac client. + + +Allow SPI cursors to handle utility commands that return rows, +such as EXPLAIN (Tom) +Fix CLUSTER failure after ALTER TABLE + SET WITHOUT OIDS (Tom) +Reduce memory usage of ALTER TABLE ADD COLUMN + (Neil) +Fix ALTER LANGUAGE RENAME (Tom) +Document the Windows-only register and +unregister options of pg_ctl (Magnus) +Ensure operations done during backend shutdown are counted by +statistics collector + + This is expected to resolve reports of pg_autovacuum + not vacuuming the system catalogs often enough — it was not being + told about catalog deletions caused by temporary table removal during + backend exit. -Enable the wal_sync_method variable value of - - - This makes Win32 behave like other supported platforms that require the - administrator to make sure that data is guaranteed to be written to permanent - storage after a sync operation. To turn off the write cache on Win32, - from the Device Manager, chose the drive properties, - then Policies. +Change the Windows default for configuration parameter + log_destination to + + By default, a server running on Windows will now send log output to the + Windows event logger rather than standard error. + +Make Kerberos authentication work on Windows (Magnus) +Allow ALTER DATABASE RENAME by superusers + who aren't flagged as having CREATEDB privilege (Tom) +Modify WAL log entries for CREATE and +DROP DATABASE to not specify absolute paths (Tom) + This allows point-in-time recovery on a different machine with possibly + different database location. Note that CREATE TABLESPACE still + poses a hazard in such situations. -Add Win32-only wal_sync_method value of -Fix crash from a backend exiting an open transaction - with a CREATE and a FETCH (Tom) +Fix crash from a backend exiting with an open transaction + that created a table and opened a cursor on it (Tom) +Fix array_map() so it can call PL functions + (Tom) +Several contrib/tsearch2 and +contrib/btree_gist fixes (Teodor) + +Fix crash of some contrib/pgcrypto + functions on some platforms (Marko Kreen) +Fix contrib/intagg for 64-bit platforms + (Tom) +Fix ecpg bugs in parsing of CREATE statement + (Michael) Work around gcc bug on powerpc and amd64 causing problems in ecpg (Christof Petig) -Modify WAL log entries for CREATE and - DROP DATABASE to not specify absolute paths - This allows point-in-time recovery on a different machine. (Tom) +Do not use locale-aware versions of upper(), + lower(), and initcap() when the locale is + C (Bruce) + + This allows these functions to work on platforms that generate errors + for non-7-bit data when the locale is C. -Fix /contrib/intagg for 64-bit platforms - (Tom) -Convert plpython function bodies containing \r\n - and \r to \n (Michael Fuhr) -Allow Kerberos to work on Win32 (Magnus) +Fix quote_ident() to quote names that match keywords (Tom) Fix to_date() to behave reasonably when CC and YY fields are both used (Karel) Prevent to_char(interval) from failing when given a zero-month interval (Tom) -Fix wrong week returned by date_trunc('week') +Fix wrong week returned by date_trunc('week') +(Bruce) - This was a problem for early January dates. date_trunc('week') - returned the wrong year for 2005-01-01 and 2006-01-01 - (Bruce) + date_trunc('week') + returned the wrong year for the first few days of January in some years. +Use the correct default mask length for class D + addresses in INET data types (Tom) -- 2.11.0