Bracketed items "[]" have more detail.

Current maintainer:Bruce Momjian (pgman@candle.pha.pa.us)

Last updated:Mon Aug16 12:14:34 EDT 2004

Last updated:Tue Aug17 13:14:48 EDT 2004

The most recent version of this document can be viewed at the PostgreSQL web site, http://www.PostgreSQL.org.

* Allow REINDEX to rebuild all database indexes, remove /contrib/reindex

* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY

* Add a schema option to createlang

* -Allow savepoints / nested transactions[transactions](Alvaro)

* -Allow savepoints / nested transactions (Alvaro)

* -Use nested transactions to prevent syntax errors from aborting a transaction

* Allow UPDATE tab SET ROW (col, ...) = (...) for updating multiple columns

* Allow SET CONSTRAINTS to be qualified by schema/table name

* Add NOVICE output level for helpful messages like automatic sequence/index creation

* Add COMMENT ON for all cluster global objects (users, groups,

databases and tablespaces)

* Add an option to automatically use savepoints for each statement in a

multi-statement transaction.

When enabled, this would allow errors in multi-statement transactions

to be automatically ignored.

* ALTER

o -ALTER TABLE ADD COLUMN does not honor DEFAULT and non-CHECK CONSTRAINT