@@ -96,15 +96,15 @@ Migration to version 7.3
9696 * 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
99- dependencies for SERIAL, UNIQUEcontraints , and foreign keys. See
99+ dependencies for SERIAL, UNIQUEconstraints , and foreign keys. See
100100 /contrib/adddepend for a detailed description and a script that
101101 will add the such dependencies.
102102
103103 ----------------------------------------------------------------------
104104
105105Changes
106106
107- 2002-09-02
107+ 2002-09-23
108108
109109Server Operation
110110================
@@ -133,6 +133,7 @@ Fix GEQO optimizer bug (Neil Conway)
133133Make WITHOUT OID actually save four bytes per row (Manfred Koizar)
134134Add GUC default_statistics_target variable to specify ANALYZE buckets (Neil)
135135Use local buffer cache for temporary tables so no WAL overhead (Tom)
136+ Improve free space map performance on large tables (Stephen Marshall, Tom)
136137
137138Privileges
138139==========
@@ -224,6 +225,8 @@ Prevent inherited columns from being removed or renamed (Alvaro Herrera)
224225Add CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE (Gavin, Neil, Tom)
225226Fix foreign key constraints to not error on intermediate db states (Stephan)
226227Propagate column or table renaming to foreign key constraints
228+ Add CREATE OR REPLACE VIEW (Gavin, Neil, Tom)
229+ Add CREATE OR REPLACE RULE (Gavin, Neil, Tom)
227230
228231Utility Commands
229232================
@@ -279,7 +282,7 @@ Limit timestamp data types to 6 decimal places of precision (Thomas)
279282Change timezone conversion functions from timetz() to timezone() (Thomas)
280283Add GUC variables datestyle and timezone (Tom)
281284Add OVERLAY(), which allows substitution of a substring in a string (Thomas)
282- Add SIMILAR TO as a synonym for our existing operator "~" (Thomas)
285+ Add SIMILAR TO as a synonym for our existing operator "~" (Thomas, Tom )
283286Add regular expression SUBSTRING(string FROM pat FOR escape) (Thomas)
284287Add LOCALTIME and LOCALTIMESTAMP functions (Thomas)
285288Add named composite types using CREATE TYPE typename AS (column) (Joe)
@@ -303,10 +306,14 @@ Increase maximum number of function parameters to 32 (Bruce)
303306No longer automatically create index for SERIAL column (Tom)
304307Add current_database() (Rod)
305308Fix cash_words() to not overflow buffer (Tom)
306- Add functions replace(),split (), to_hex() (Joe)
309+ Add functions replace(),split_part (), to_hex() (Joe)
307310Fix LIKE for bytea as a right-hand argument (Joe)
308311Prevent crashes caused by SELECT cash_out(2)
309312Triggers are now fired in alphabetical order (Tom)
313+ Add /contrib/adddepend to handle pre-7.3 object dependencies (Rod)
314+ Allow better casting when INSERTing/UPDATing values (Tom)
315+ Fix to_char(1,'FM999.99') to return a period (Karel)
316+ Fix trigger/type/language functions returning OPAQUE to return proper type (Tom)
310317
311318Internationalization
312319====================
@@ -366,6 +373,7 @@ Add jdbc query cancel capability
366373Add refresh row to jdbc (Dave)
367374Fix jdbc MD5 encryption handling for multibyte servers (Jun Kawai)
368375Add JDBC support for prepared statements (Barry)
376+ Add support for new prepared statements
369377
370378ECPG
371379====
@@ -381,6 +389,7 @@ Move /interfaces/odbc to http://gborg.postgresql.org (Marc)
381389Move /interfaces/libpgeasy to http://gborg.postgresql.org (Marc, Bruce)
382390Move /interfaces/perl5 to http://gborg.postgresql.org (Marc, Bruce)
383391Remove /bin/pgaccess from main tree, now at http://www.pgaccess.org (Bruce)
392+ Add pg_on_connection_loss command to libpgtcl (Gerhard Hintermayer, Tom)
384393
385394Build and Install
386395=================
@@ -399,6 +408,10 @@ Fix for Win9x DLL creation (Magnus Naeslund)
399408Fix for link() usage by WAL code on Win32, Netware, BeOS (Jason Tishler)
400409Add sys/types.h to c.h, remove from main files (Peter, Bruce)
401410Fix AIX hang on SMP machines (Tomoyuki Niijima)
411+ AIX SMP hang fix (Tomoyuki Niijima)
412+ Fix pre-1970 date handling on newer glibc libraries (Tom)
413+ Fix PowerPC SMP locking (Tom)
414+ Prevent gcc -ffast-math from being used (Tom)
402415
403416Source Code
404417===========
@@ -430,6 +443,7 @@ Remove OPAQUE and create specific subtypes (Tom)
430443Cleanups in array internal handling (Joe, Tom)
431444Disallow pg_atoi('') (Bruce)
432445Remove GUC parameter wal_files because WAL files are now recycled (Bruce)
446+ Add version numbers to heap pages (Tom)
433447
434448
435449Contrib