@@ -65,9 +65,11 @@ Overview
6565Migration to version 7.3
6666
6767 A dump/restore using "pg_dump" is required for those wishing to migrate
68- data from any previous release. A summary of changes needed in client
69- applications is at
70- http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3.
68+ data from any previous release. If your application examines the
69+ system catalogs, additional changes will be required due to the
70+ introduction of schemas in 7.3; for more information, see
71+
72+ http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3
7173
7274 Observe the following incompatibilities:
7375
@@ -79,21 +81,19 @@ Migration to version 7.3
7981
8082 * LIMIT #,# is disabled, use LIMIT # OFFSET #.
8183
82- * LIMIT can now appear before FOR UPDATE, for portability.
83-
8484 * INSERTs with column lists must specify all values, e.g.
85- INSERT INTO tab (col1, col2) VALUES ('val1') is now invalid
85+ INSERT INTO tab (col1, col2) VALUES ('val1') is now invalid.
8686
8787 * DROP object now takes either CASCADE or RESTRICT to control
88- whether dependent objects are also dropped
88+ whether dependent objects are also dropped.
8989
90- * An index is now not automatically created for SERIAL columns
90+ * An index is now not automatically created for SERIAL columns.
9191
92- * A SET inside an aborted transaction is now rolled back
92+ * A SET inside an aborted transaction is now rolled back.
9393
94- * COPY no longer considers missing trailing columns to be NULL
94+ * COPY no longer considers missing trailing columns to be NULL.
9595
96- * TIMESTAMP and TIME data types now default to WITHOUT TIMEZONE
96+ * TIMESTAMP and TIME data types now default to WITHOUT TIMEZONE.
9797
9898 * Pre-7.3 databases loaded into 7.3 will not have the new object
9999 dependencies for SERIAL, UNIQUE constraints, and foreign keys. See
@@ -176,7 +176,7 @@ Queries
176176=======
177177Make cursors insensitive, meaning their contents do not change (Tom)
178178Disable LIMIT #,# syntax; now only LIMIT # OFFSET # supported (Bruce)
179- Increase identifier length to64 (Neil, Bruce)
179+ Increase identifier length to63 (Neil, Bruce)
180180UNION fixes for merging >= 3 columns of different lengths (Tom)
181181Add DEFAULT keyword to INSERT, i.e INSERT ... (..., DEFAULT, ) (Rod)
182182Allow views to have default values using ALTER COLUMN ... SET DEFAULT (Neil)
@@ -222,7 +222,6 @@ Automatically drop constraints/functions when object is dropped (Rod)
222222Add CREATE/DROP OPERATOR CLASS (Bill Studenmund, Tom)
223223Add ALTER TABLE DROP COLUMN (Christopher, Tom, Hiroshi)
224224Prevent inherited columns from being removed or renamed (Alvaro Herrera)
225- Add CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE (Gavin, Neil, Tom)
226225Fix foreign key constraints to not error on intermediate db states (Stephan)
227226Propagate column or table renaming to foreign key constraints
228227Add CREATE OR REPLACE VIEW (Gavin, Neil, Tom)
@@ -336,7 +335,8 @@ Allow recursive SQL function (Peter)
336335Change PL/Tcl build to use configured compiler and Makefile.shlib (Peter)
337336Overhaul the PL/pgSQL FOUND variable to be more Oracle-compatible (Tom, Neil)
338337Allow PL/pgSQL to handle quoted identifiers (Tom)
339- Allow PL/pgSQL functions can return sets (Neil)
338+ Allow set-returning PL/pgSQL functions (Neil)
339+ Make PL/pgSQL schema-aware (Joe)
340340
341341Psql
342342====
@@ -367,13 +367,12 @@ Allow jdbc to compile with jdk 1.4 (Dave)
367367Add jdbc3 support (Barry)
368368Allows jdbc to set loglevel by adding ?loglevel=X to the connection URL (Barry)
369369Add jdbc Driver.info() message that prints out the version number (Barry)
370- Add jdbc updateable result sets
371- Add jdbc support for callable statements
370+ Add jdbc updateable result sets (Raghu Nidagal, Dave)
371+ Add jdbc support for callable statements (Paul Bethe)
372372Add jdbc query cancel capability
373373Add refresh row to jdbc (Dave)
374374Fix jdbc MD5 encryption handling for multibyte servers (Jun Kawai)
375375Add JDBC support for prepared statements (Barry)
376- Add support for new prepared statements
377376
378377ECPG
379378====