@@ -104,7 +104,7 @@ Migration to version 7.3
104
104
105
105
Changes
106
106
107
- 2002-09 -23
107
+ 2002-10 -23
108
108
109
109
Server Operation
110
110
================
@@ -134,6 +134,7 @@ 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
136
Improve free space map performance on large tables (Stephen Marshall, Tom)
137
+ Improved WAL write concurrency (Tom)
137
138
138
139
Privileges
139
140
==========
@@ -226,6 +227,7 @@ Fix foreign key constraints to not error on intermediate db states (Stephan)
226
227
Propagate column or table renaming to foreign key constraints
227
228
Add CREATE OR REPLACE VIEW (Gavin, Neil, Tom)
228
229
Add CREATE OR REPLACE RULE (Gavin, Neil, Tom)
230
+ Have rules execute alphabetically, returning more accurate values (Tom)
229
231
230
232
Utility Commands
231
233
================
@@ -254,14 +256,16 @@ Fix CLUSTER to preserve all table attributes (Alvaro Herrera)
254
256
New pg_settings table to view/modify GUC settings (Joe)
255
257
Add smart quoting, portability improvements to pg_dump output (Peter)
256
258
Dump serial columns out as SERIAL (Tom)
257
- Enable large file support, >2G for pg_dump (Peter)
259
+ Enable large file support, >2G for pg_dump (Peter, Philip Warner, Bruce )
258
260
Disallow TRUNCATE on tables that are involved in referential constraints (Rod)
259
261
Have TRUNCATE also auto-truncate the toast table of the relation (Tom)
260
262
Add clusterdb utility that will auto-cluster an entire database based on
261
263
previous CLUSTER operations (Alvaro Herrera)
262
264
Overhaul pg_dumpall (Peter)
263
265
Allow REINDEX of TOAST tables (Tom)
264
266
Implemented START TRANSACTION, per SQL99 (Neil)
267
+ Fix rare index corruption when a page split affects bulk delete (Tom)
268
+ Fix ALTER TABLE ... ADD COLUMN for inheritance (Alvaro Herrera)
265
269
266
270
Data Types and Functions
267
271
========================
@@ -337,6 +341,7 @@ Overhaul the PL/pgSQL FOUND variable to be more Oracle-compatible (Tom, Neil)
337
341
Allow PL/pgSQL to handle quoted identifiers (Tom)
338
342
Allow set-returning PL/pgSQL functions (Neil)
339
343
Make PL/pgSQL schema-aware (Joe)
344
+ Remove some memory leaks (Nigel J. Andrews, Tom)
340
345
341
346
Psql
342
347
====
@@ -350,6 +355,7 @@ Allow psql \d to show temporary table structure (Tom)
350
355
Allow psql \d to show foreign keys (Rod)
351
356
Fix \? to honor \pset pager (Bruce)
352
357
Have psql reports its version number on startup (Tom)
358
+ Allow \copy to specify column names (Tom)
353
359
354
360
Libpq
355
361
=====
@@ -411,6 +417,7 @@ AIX SMP hang fix (Tomoyuki Niijima)
411
417
Fix pre-1970 date handling on newer glibc libraries (Tom)
412
418
Fix PowerPC SMP locking (Tom)
413
419
Prevent gcc -ffast-math from being used (Tom)
420
+ Bison >= 1.50 now required for developer builds
414
421
415
422
Source Code
416
423
===========