7.4 status

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)
  

? psql
Index: help.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/psql/help.c,v
retrieving revision 1.80
diff -u -r1.80 help.c
--- help.c	14 Sep 2003 22:37:13 -0000	1.80
+++ help.c	1 Oct 2003 19:58:15 -0000
@@ -234,8 +234,8 @@
 			ON(pset.popt.topt.format == PRINT_HTML));
 	fprintf(output, _("  \\pset NAME [VALUE]\n"
 					  "                 set table output option\n"
-					  "                 (NAME := {format|border|expanded|fieldsep|null|recordsep|\n"
-			  "                 tuples_only|title|tableattr|pager})\n"));
+					  "                 (NAME := {format|border|expanded|fieldsep|footer|null|\n"
+			  "                 recordsep|tuples_only|title|tableattr|pager})\n"));
 	fprintf(output, _("  \\t             show only rows (currently %s)\n"),
 			ON(pset.popt.topt.tuples_only));
 	fprintf(output, _("  \\T [STRING]    set HTML <table> tag attributes, or unset if none\n"));