@@ -96,15 +96,15 @@ Migration to version 7.3
96
96
* TIMESTAMP and TIME data types now default to WITHOUT TIMEZONE
97
97
98
98
* Pre-7.3 databases loaded into 7.3 will not have the new object
99
- dependencies for SERIAL, UNIQUE contraints , and foreign keys. See
99
+ dependencies for SERIAL, UNIQUE constraints , and foreign keys. See
100
100
/contrib/adddepend for a detailed description and a script that
101
101
will add the such dependencies.
102
102
103
103
----------------------------------------------------------------------
104
104
105
105
Changes
106
106
107
- 2002-09-02
107
+ 2002-09-23
108
108
109
109
Server Operation
110
110
================
@@ -133,6 +133,7 @@ Fix GEQO optimizer bug (Neil Conway)
133
133
Make WITHOUT OID actually save four bytes per row (Manfred Koizar)
134
134
Add GUC default_statistics_target variable to specify ANALYZE buckets (Neil)
135
135
Use local buffer cache for temporary tables so no WAL overhead (Tom)
136
+ Improve free space map performance on large tables (Stephen Marshall, Tom)
136
137
137
138
Privileges
138
139
==========
@@ -224,6 +225,8 @@ Prevent inherited columns from being removed or renamed (Alvaro Herrera)
224
225
Add CREATE OR REPLACE VIEW, CREATE OR REPLACE RULE (Gavin, Neil, Tom)
225
226
Fix foreign key constraints to not error on intermediate db states (Stephan)
226
227
Propagate 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)
227
230
228
231
Utility Commands
229
232
================
@@ -279,7 +282,7 @@ Limit timestamp data types to 6 decimal places of precision (Thomas)
279
282
Change timezone conversion functions from timetz() to timezone() (Thomas)
280
283
Add GUC variables datestyle and timezone (Tom)
281
284
Add 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 )
283
286
Add regular expression SUBSTRING(string FROM pat FOR escape) (Thomas)
284
287
Add LOCALTIME and LOCALTIMESTAMP functions (Thomas)
285
288
Add named composite types using CREATE TYPE typename AS (column) (Joe)
@@ -303,10 +306,14 @@ Increase maximum number of function parameters to 32 (Bruce)
303
306
No longer automatically create index for SERIAL column (Tom)
304
307
Add current_database() (Rod)
305
308
Fix cash_words() to not overflow buffer (Tom)
306
- Add functions replace(), split (), to_hex() (Joe)
309
+ Add functions replace(), split_part (), to_hex() (Joe)
307
310
Fix LIKE for bytea as a right-hand argument (Joe)
308
311
Prevent crashes caused by SELECT cash_out(2)
309
312
Triggers 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)
310
317
311
318
Internationalization
312
319
====================
@@ -366,6 +373,7 @@ Add jdbc query cancel capability
366
373
Add refresh row to jdbc (Dave)
367
374
Fix jdbc MD5 encryption handling for multibyte servers (Jun Kawai)
368
375
Add JDBC support for prepared statements (Barry)
376
+ Add support for new prepared statements
369
377
370
378
ECPG
371
379
====
@@ -381,6 +389,7 @@ Move /interfaces/odbc to http://gborg.postgresql.org (Marc)
381
389
Move /interfaces/libpgeasy to http://gborg.postgresql.org (Marc, Bruce)
382
390
Move /interfaces/perl5 to http://gborg.postgresql.org (Marc, Bruce)
383
391
Remove /bin/pgaccess from main tree, now at http://www.pgaccess.org (Bruce)
392
+ Add pg_on_connection_loss command to libpgtcl (Gerhard Hintermayer, Tom)
384
393
385
394
Build and Install
386
395
=================
@@ -399,6 +408,10 @@ Fix for Win9x DLL creation (Magnus Naeslund)
399
408
Fix for link() usage by WAL code on Win32, Netware, BeOS (Jason Tishler)
400
409
Add sys/types.h to c.h, remove from main files (Peter, Bruce)
401
410
Fix 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)
402
415
403
416
Source Code
404
417
===========
@@ -430,6 +443,7 @@ Remove OPAQUE and create specific subtypes (Tom)
430
443
Cleanups in array internal handling (Joe, Tom)
431
444
Disallow pg_atoi('') (Bruce)
432
445
Remove GUC parameter wal_files because WAL files are now recycled (Bruce)
446
+ Add version numbers to heap pages (Tom)
433
447
434
448
435
449
Contrib
0 commit comments