On Mon, 2003-09-29 at 14:57, Bruce Momjian wrote:
> I have emptied the patch queue, and have updated the HISTORY file for
> 7.4. I am looking for any improvements to that file. (I have to move
> it to SGML soon.)
A patch that improves HISTORY is attached. I added a few bullet items to
the "highlights of this release section" that are IMHO important,
removed the mention of hash indexes (IMHO, they are still inappropriate
for production use, just less so), fixed some spelling mistakes, and
clarified a few entries.
Please apply.
-Neil
Index: HISTORY
===================================================================
RCS file: /var/lib/cvs/pgsql-server/HISTORY,v
retrieving revision 1.216
diff -c -r1.216 HISTORY
*** HISTORY 29 Sep 2003 18:06:48 -0000 1.216
--- HISTORY 29 Sep 2003 20:26:57 -0000
***************
*** 15,52 ****
Major changes in this release:
IPv6
! Full support for IPv6 connections and IPv6 data types.
SSL
! Major SSL improvements in performance and security.
Index Growth Prevention
Allow free space map to efficiently reused empty index pages,
! and other free space improvements.
New Client/Server Communication Protocol
! New protocol improves connection speed/reliability, and adds
! error codes, status information, a binary protocol, error
! reporting verbosity, and cleaner startup packets.
Performance
! IN/NOT IN subqueries now perform as efficiently as joins
! Improved GROUP BY procesing by using hack buckets
! Hash indexes now have better concurrency/reliability/performance
! New multi-key hash join capability
! ANSI joins are now fully optimized
! Faster regular expression code
! Cursors
! Allow cursors to exist outside transactions
Threads
! libpq and ecpg are now fully thread-safe with --enable-thread-safety
Contrib
! New version of full text indexing (tsearch2)
! New autovacuum tool
! Array handling has been improved and moved into the main server
_________________________________________________________________
--- 15,57 ----
Major changes in this release:
IPv6
! Full support for IPv6 connections and IPv6 address data types
SSL
! Major improvements in SSL performance and security
Index Growth Prevention
Allow free space map to efficiently reused empty index pages,
! and other free space management improvements.
!
! Standards Compliance
! Implement information schema
! Support for read-only transactions
! Make cursors comply more closely with the SQL standard
New Client/Server Communication Protocol
! New protocol improves connection speed/reliability, and adds
! error codes, status information, a binary protocol, error
! reporting verbosity, and cleaner startup packets.
Performance
! IN/NOT IN subqueries now perform as efficiently as joins
! Improved GROUP BY processing by using hash buckets
! New multi-key hash join capability
! ANSI joins are now fully optimized
! Faster regular expression code
! Function-inlining for simple SQL functions
! Holdable Cursors
! Allow cursors to exist outside transactions
Threads
! libpq and ecpg are now fully thread-safe with --enable-thread-safety
Contrib
! New version of full text indexing (tsearch2)
! New autovacuum tool
! Array handling has been improved and moved into the main server
_________________________________________________________________
***************
*** 58,75 ****
Observe the following incompatibilities:
* The server-side autocommit setting was removed an reimplemented
in client applications and languages.
! * Error message wording has changed dramtically in this release,
and error codes have been added.
* ANSI joins may behave differently because they are now fully optimized
* A number of server variables have been renamed for clarity
* MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
varies based on the current offset in the cursor
! * COPY now can process carriage-return/line-feed and carraige-return
terminated files. Literal carriage-returns and line-feeds are no
longer accepted as data values; use \r and \n instead.
! * Auto-trim spaces when converting from CHAR() to VARCHAR()/TEXT
* FLOAT(p) now measures 'p' in bits, not digits
* Date values now must match the ordering specified by DateStyle
_________________________________________________________________
--- 63,83 ----
Observe the following incompatibilities:
* The server-side autocommit setting was removed an reimplemented
in client applications and languages.
! * Error message wording has changed dramatically in this release,
and error codes have been added.
* ANSI joins may behave differently because they are now fully optimized
* A number of server variables have been renamed for clarity
* MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
varies based on the current offset in the cursor
! * COPY now can process carriage-return/line-feed and carriage-return
terminated files. Literal carriage-returns and line-feeds are no
longer accepted as data values; use \r and \n instead.
! * Trailing spaces are now trimmed when converting from CHAR(n) to
! VARCHAR(n)/TEXT
* FLOAT(p) now measures 'p' in bits, not digits
* Date values now must match the ordering specified by DateStyle
+ * The oidrand(), oidsrand(), and userfntest() functions have been
+ removed.
_________________________________________________________________
***************
*** 177,190 ****
Object Manipulation
Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil)
! Add FOR EACH STATEMENT statement-level triggers (Neil Conway)
Add DOMAIN CHECK constraints (Rod)
Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
CONSTRAINT (Rod)
Fix several zero-column table bugs (Tom)
Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)
Add ALTER DOMAIN OWNER (Rod)
! Add ALTER TABLE ... WITHOUT OIDS? (Rod)
Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values (Rod)
Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)
Improve DOMAIN automatic type casting (Rod, Tom)
--- 185,198 ----
Object Manipulation
Make CREATE SEQUENCE grammar more SQL1999 standards compliant (Neil)
! Add FOR EACH STATEMENT statement-level triggers (Neil)
Add DOMAIN CHECK constraints (Rod)
Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD / DROP
CONSTRAINT (Rod)
Fix several zero-column table bugs (Tom)
Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)
Add ALTER DOMAIN OWNER (Rod)
! Add ALTER TABLE ... WITHOUT OIDS (Rod)
Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values (Rod)
Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)
Improve DOMAIN automatic type casting (Rod, Tom)
***************
*** 225,231 ****
Allow pg_dumpall to support the -a, -s, -x options of pg_dump (Tom)
Prevent pg_dump from lowercasing identifiers specified on the command line (Tom)
Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)
! Allow EXPLAIN EXECUTE (Neil)
Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
CHECK constraints (Christopher)
Improve VACUUM performance on indexes by reducing WAL traffic (Tom)
--- 233,239 ----
Allow pg_dumpall to support the -a, -s, -x options of pg_dump (Tom)
Prevent pg_dump from lowercasing identifiers specified on the command line (Tom)
Allow PREPARE/bind of utility commands like FETCH and EXPLAIN (Tom)
! Add EXPLAIN EXECUTE (Neil)
Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
CHECK constraints (Christopher)
Improve VACUUM performance on indexes by reducing WAL traffic (Tom)
***************
*** 235,241 ****
Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)
Have COMMENT ON DATABASE on non-local database generate a warning (Rod)
Improve reliability of LISTEN/NOTIFY (Tom)
! Allow REINDEX to reliabily reindex all indexes, except global ones (Tom)
pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
all dumps use SET SESSION AUTHORIZATION
--- 243,249 ----
Have SHOW TRANSACTION_ISOLATION match input to SET TRANSACTION_ISOLATION (Tom)
Have COMMENT ON DATABASE on non-local database generate a warning (Rod)
Improve reliability of LISTEN/NOTIFY (Tom)
! Allow REINDEX to reliably reindex non-shared system catalog indexes (Tom)
pg_dump --use-set-session-authorization and --no-reconnect now do nothing,
all dumps use SET SESSION AUTHORIZATION
***************
*** 289,295 ****
'now' will no longer work as a column default, use now() (change required for
prepared statements) (Tom)
Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)
! Prevent interval from supressing ':00' seconds display
New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions
Allow time to be specified as '040506' or '0405' (Tom)
--- 297,303 ----
'now' will no longer work as a column default, use now() (change required for
prepared statements) (Tom)
Assume NaN value to be larger than any other value in MIN()/MAX() (Tom)
! Prevent interval from suppressing ':00' seconds display
New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible() functions
Allow time to be specified as '040506' or '0405' (Tom)
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
