@@ -18,7 +18,7 @@ Overview
18
18
19
19
Drop Column
20
20
21
- PostgreSQL now support ALTER TABLE ... DROP COLUMN functionality.
21
+ PostgreSQL now supports ALTER TABLE ... DROP COLUMN functionality.
22
22
23
23
Table Functions
24
24
@@ -42,7 +42,7 @@ Overview
42
42
43
43
Multibyte/Locale
44
44
45
- Both multibyte and locale are now enabled by default .
45
+ Both multibyte and locale are now always enabled .
46
46
47
47
Logging
48
48
@@ -57,7 +57,7 @@ Overview
57
57
Functions/Identifiers
58
58
59
59
By default, functions can now take up to 32 parameters, and
60
- identifiers can be up to 64 bytes long.
60
+ identifiers can be up to 63 bytes long.
61
61
62
62
----------------------------------------------------------------------
63
63
@@ -101,7 +101,7 @@ Changes
101
101
Server Operation
102
102
================
103
103
Kerberos V Heimdal support (KTH)
104
- Add pg_locks table to show locks (Neil)
104
+ Add pg_locks view to show locks (Neil)
105
105
Security fixes for password negotiation memory allocation (Neil)
106
106
Remove support for version 0, <=6.2 FE/BE protocol (Tom)
107
107
Reserve the last few backend slots for superusers, add GUC variable
@@ -115,12 +115,10 @@ Improve caching of index information (Tom)
115
115
Optimizer improvements (Tom, Fernando Nasser)
116
116
Catalog caches now store failed lookups (Tom)
117
117
Hash function improvements (Neil)
118
- EXPLAIN now outputs as a query (Tom)
119
118
Improve performance of query tokenization and network handling (Peter)
120
119
Speed improvement for large object restore (Mario Weilguni)
121
120
Mark expired index entries on first lookup, saving later heap fetches (Tom)
122
121
Eliminate NULL bitmap padding when not required (Manfred)
123
- Display sort keys in EXPLAIN (Tom)
124
122
Add BSD-licensed qsort() for Solaris, for performance (Bruce)
125
123
Reduce per-row overhead by four bytes (Manfred Koizar)
126
124
Fix GEQO optimizer bug (Neil Conway)
@@ -228,9 +226,11 @@ Make pg_dump use ALTER TABLE ADD PRIMARY KEY, for performance (Neil)
228
226
Disable brackets in multi-statement rules (Bruce)
229
227
Disable VACUUM from being called inside a function (Bruce)
230
228
Allow dropdb and other scripts to use identifiers with spaces (Bruce)
231
- Restrict comments to the current database
229
+ Restrict comment to the current database
232
230
Allow comments on operators, independent of the underlying function (Rod)
233
231
Rollback SET commands in aborted transactions (Tom)
232
+ EXPLAIN now outputs as a query (Tom)
233
+ Display sort keys in EXPLAIN (Tom)
234
234
Add 'SET LOCAL var = value' to set GUC variables for a single transaction (Tom)
235
235
Allow ANALYZE to run in a transaction (Bruce)
236
236
Improve COPY syntax using new WITH clauses, keep backward compatibility (Bruce)
@@ -291,7 +291,7 @@ Allow bit string constants without fully-specified length (Thomas)
291
291
Allow conversion between 8-byte integers and bit strings (Thomas)
292
292
Implement hex literal conversion to bit string literal (Thomas)
293
293
Allow table functions to appear in the FROM clause (Joe)
294
- Increase maximum number of function parameters to 32 (Bruce) momjian
294
+ Increase maximum number of function parameters to 32 (Bruce)
295
295
No longer automatically create index for SERIAL column (Tom)
296
296
Add current_database() (Rod)
297
297
Fix cash_words() to not overflow buffer (Tom)
@@ -412,12 +412,12 @@ Rename some internal identifiers to simplify Win32 compile (Jan, Katherine Ward)
412
412
Add documentation on computing disk space (Bruce)
413
413
Remove KSQO from GUC (Bruce)
414
414
Fix memory leak in rtree (Kenneth Been)
415
- Modify a few error messages for consistency (Bruce) momjian
415
+ Modify a few error messages for consistency (Bruce)
416
416
Remove unused system table columns (Peter)
417
417
Make system columns NOT NULL where appropriate (Tom)
418
418
Clean up use of sprintf in favor of snprintf()
419
419
Remove OPAQUE and create specific subtypes (Tom)
420
- Cleanups in array internal handling (Tom )
420
+ Cleanups in array internal handling (Joe )
421
421
Disallow pg_atoi('') (Bruce)
422
422
Remove GUC parameter wal_files because WAL files are now recycled (Bruce)
423
423
0 commit comments