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)