forked from IvorySQL/IvorySQL
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathHISTORY
4748 lines (4201 loc) · 215 KB
/
HISTORY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
Release Notes
Release 7.4
_________________________________________________________________
Overview
Major changes in this release:
IPv6
Full support for IPv6 connections and IPv6 address data types
SSL
Major improvements in SSL performance and reliability
Index Growth Prevention
Allow free space map to efficiently reuse empty index pages,
and other free space management improvements.
Standards Compliance
Implement information schema Support for read-only transactions
Make cursors comply more closely with the SQL standard
New Client/Server Communication Protocol
New protocol improves connection speed/reliability, and adds
error codes, status information, a binary protocol, error
reporting verbosity, and cleaner startup packets.
Performance
IN/NOT IN subqueries now perform as efficiently as joins
Improved GROUP BY processing by using hash buckets
New multi-key hash join capability
ANSI joins are now better optimized
Faster and more powerful regular expression code
Function-inlining for simple SQL functions
Holdable Cursors
Allow cursors to exist outside transactions
Threads
libpq and ecpg are now fully thread-safe with
--enable-thread-safety
Contrib
New version of full text indexing (tsearch2)
New autovacuum tool
Array handling has been improved and moved into the main server
_________________________________________________________________
Migration to version 7.4
A dump/restore using pg_dump is required for those wishing to migrate
data from any previous release.
Observe the following incompatibilities:
* The server-side autocommit setting was removed and reimplemented
in client applications and languages.
* Error message wording has changed substantially in this release,
and error codes have been added.
* ANSI joins may behave differently because they are now better
optimized
* A number of server variables have been renamed for clarity
* MOVE/FETCH 0 now does nothing; return value of MOVE/FETCH 1/0
varies based on the current offset in the cursor
* COPY now can process carriage-return/line-feed and carriage-return
terminated files. Literal carriage-returns and line-feeds are no
longer accepted as data values; use \r and \n instead.
* Trailing spaces are now trimmed when converting from CHAR(n) to
VARCHAR(n) / TEXT
* FLOAT(p) now measures 'p' in bits, not digits
* Ambiguous date values now must match the ordering specified by
DateStyle
* The oidrand(), oidsrand(), and userfntest() functions have been
removed.
* 'now' will no longer work as a column default; now() or
CURRENT_TIMESTAMP should be used instead
* 'today' will no longer work as a column default; CURRENT_DATE
should be used instead
* Dollar sign ($) is no longer allowed in operator names
* Dollar sign ($) can be a non-first character in identifiers
_________________________________________________________________
Changes
Server Operation
* Allow IPv6 server connections (Nigel Kukard, Johan Jordaan, Bruce,
Tom, Kurt Roeckx, Andrew Dunstan)
* Fix SSL to handle errors cleanly (Nathan Mueller)
* SSL protocol security and performance improvements (Sean
Chittenden)
* Print lock information when a deadlock is detected (Tom)
* Update "/tmp" socket mod. times regularly to avoid their removal
(Tom)
* Enable PAM for MAC OS X (Aaron Hillegass)
* Make btree indexes fully WAL-safe (Tom)
* Allow btree index compaction and empty page reuse (Tom)
* Fix inconsistent index lookups during split of first root page
(Tom)
* Improve free space map allocation logic (Tom)
* Preserve free space information between postmaster restarts (Tom)
* Set proper schema permissions in initdb (Peter)
* Add start time to pg_stat_activity (Neil)
* New code to detect corrupt disk pages; erase with
zero_damaged_pages (Tom)
* New client/server protocol: faster, no username length limit,
allow clean exit from COPY (Tom)
* Add transaction status, tableid, columnid to backend protocol
(Tom)
* Add new binary I/O protocol (Tom)
* Remove autocommit server setting; move to client applications
(Tom)
* New error message wording, error codes, and three levels of error
detail (Tom)
_________________________________________________________________
Performance
* Add hashing for GROUP BY aggregates (Tom)
* Allow nested loops to be smarter about multicolumn indexes (Tom)
* Allow multi-key hash joins (Tom)
* Improve constant folding (Tom)
* Add ability to inline simple SQL functions (Tom)
* Reduce memory usage for queries using complex functions (Tom)
* Improve GEQO optimizer performance (Tom)
* Allow IN/NOT IN to be handled via hash tables (Tom)
* Improve NOT IN (subquery) performance (Tom)
* Allow most IN subqueries to be processed as joins (Tom)
* Allow the postmaster to preload libraries using preload_libraries
(Joe)
* Improve optimizer cost computations, particularly for subqueries
(Tom)
* Avoid sort when subquery ORDER BY matches upper query (Tom)
* Assume WHERE a.x = b.y and b.y = 42 also means a.x = 42 (Tom)
* Allow hash/merge joins on complex joins (Tom)
* Allow hash joins for more data types (Tom)
* Allow join optimization of ANSI joins, disable with
join_collapse_limit (Tom)
* Add from_collapse_limit to control conversion of subqueries to
joins (Tom)
* Use faster regular expression code from TCL (Henry Spencer, Tom)
* Use bit-mapped relation sets in the optimizer (Tom)
* Improve backend startup time (Tom)
* Improve trigger/constraint performance (Stephan)
* Improve speed of col IN (const, const, const, ...) (Tom)
* Fix hash indexes which were broken in rare cases (Tom)
* Improve hash index concurrency and speed (Tom)
* Align shared buffers on 32-byte boundary for copy speed
improvement (Manfred Spraul)
_________________________________________________________________
Server Configuration
* Rename server parameter server_min_messages to log_min_messages
(Bruce)
* Rename show_*_stats to log_*_stats (Bruce)
* Rename show_source_port to log_source_port (Bruce)
* Rename hostname_lookup to log_hostname (Bruce)
* Add checkpoint_warning to warn of excessive checkpointing (Bruce)
* New read-only server parameters for localization (Tom)
* Change debug server log messages to output as DEBUG rather than
LOG (Bruce)
* Prevent server log variables from being turned off by non-super
users (Bruce)
* log_min_messages/client_min_messages now controls debug_* output
(Bruce)
* Add Rendezvous server support (Chris Campbell)
* Add ability to print only slow statements using
log_min_duration_statement (Christopher)
* Allow pg_hba.conf to accept netmasks in CIDR format (Andrew
Dunstan)
* New is_superuser read-only variable (Tom)
* New server-side parameter log_error_verbosity to control error
detail (Tom)
* postgres --help-config now dumps server config variables (Aizaz
Ahmed)
* Make default shared_buffers 1000 and max_connections 100, if
possible (Tom)
* Add new columns in pg_settings: context, type, source , min_val,
max_val (Joe)
* New pg_hba.conf 'hostnossl' to prevent SSL connections (Jon
Jensen)
* Remove geqo_random_seed server parameter (Tom)
_________________________________________________________________
Queries
* New SQL-standard information schema (Peter)
* Add read-only transactions (Peter)
* Add server variable regex_flavor to control regular expression
processing (Tom)
* Print key name and value in foreign-key violation messages (Dmitry
Tkach)
* Allow users to see their own queries in pg_stat_activity (Kevin
Brown)
* Fix subquery aggregates of upper query columns to match SQL spec.
(Tom)
* Add option to prevent auto-addition of tables referenced in query
(Nigel J. Andrews)
* Allow UPDATE ... SET col = DEFAULT (Rod)
* Allow expressions to be used in LIMIT/OFFSET (Tom)
* Change EXECUTE INTO to CREATE TABLE AS EXECUTE (Peter)
_________________________________________________________________
Object Manipulation
* Make CREATE SEQUENCE grammar more SQL1999 standards compliant
(Neil)
* Add FOR EACH STATEMENT statement-level triggers (Neil)
* Add DOMAIN CHECK constraints (Rod)
* Add ALTER DOMAIN .. SET / DROP NOT NULL, SET / DROP DEFAULT, ADD /
DROP CONSTRAINT (Rod)
* Fix several zero-column table bugs (Tom)
* Have ALTER TABLE ... ADD PRIMARY KEY add NOT NULL constraint (Rod)
* Add ALTER DOMAIN OWNER (Rod)
* Add ALTER TABLE ... WITHOUT OIDS (Rod)
* Add ALTER SEQUENCE to modify min/max/increment/cache/cycle values
(Rod)
* Add ALTER TABLE ... CLUSTER ON (Alvaro Herrera)
* Improve DOMAIN automatic type casting (Rod, Tom)
* Allow dollar signs in identifiers, except as first character (Tom)
* Disallow dollar signs in operator names, so x=$1 works (Tom)
* Allow SQL200X inheritance syntax LIKE *subtable*, INCLUDING
DEFAULTS (Rod)
* Add WITH GRANT OPTION clause to GRANT, per SQL spec (Peter)
_________________________________________________________________
Utility Commands
* Add ON COMMIT PRESERVE ROWS for temp tables (Gavin)
* Allow cursors outside transactions using WITH HOLD (Neil)
* Make MOVE/FETCH 0 actually move/fetch 0 (Bruce)
* Cause FETCH 1 to return the current cursor row, or zero if at
beginning/end of cursor, per SQL spec (Bruce)
* Have MOVE return 0 or 1 depending on cursor position (Bruce)
* Properly handle SCROLL with cursors, or report an error (Neil)
* Implement SQL92-compatible FIRST, LAST, ABSOLUTE n, RELATIVE n
options for FETCH and MOVE (Tom)
* Allow EXPLAIN on DECLARE CURSOR (Tom)
* Allow CLUSTER to use index marked as pre-clustered by default
(Alvaro Herrera)
* Allow CLUSTER to cluster all tables (Alvaro Herrera)
* Prevent CLUSTER on partial indexes (Tom)
* Allow \r and \r\n termination for COPY files (Bruce)
* Disallow literal carriage return as a data value,
backslash-carriage-return and \r are still allowed (Bruce)
* COPY changes (binary, \.)? (Tom)
* Recover from COPY IN/OUT failure cleanly (Tom)
* Prevent possible memory leaks in COPY (Tom)
* Make TRUNCATE transaction-safe (Rod)
* Multiple pg_dump fixes, including tar format and large objects
* Allow pg_dump to dump specific schemas (Neil)
* Allow pg_dump to preserve column storage characteristics
(Christopher)
* Allow pg_dump to preserve CLUSTER characteristics (Christopher)
* Have pg_dumpall use GRANT/REVOKE to dump database-level
permissions (Tom)
* Allow pg_dumpall to support the -a, -s, -x options of pg_dump
(Tom)
* Prevent pg_dump from lowercasing identifiers specified on the
command line (Tom)
* Allow PREPARE/bind of utility commands like FETCH and EXPLAIN
(Tom)
* Add EXPLAIN EXECUTE (Neil)
* Allow pg_get_constraintdef() to support UNIQUE, PRIMARY KEY and
CHECK constraints (Christopher)
* Improve VACUUM performance on indexes by reducing WAL traffic
(Tom)
* Allow pg_ctl to better handle non-standard ports (Greg)
* Functional indexes now support indexes on column expressions (Tom)
* Syntax errors now reported as 'syntax error' rather than 'parse
error' (Tom)
* Have SHOW TRANSACTION_ISOLATION match input to SET
TRANSACTION_ISOLATION (Tom)
* Have COMMENT ON DATABASE on non-local database generate a warning
(Rod)
* Improve reliability of LISTEN/NOTIFY (Tom)
* Allow REINDEX to reliably reindex non-shared system catalog
indexes (Tom)
* pg_dump --use-set-session-authorization and --no-reconnect now do
nothing, all dumps use SET SESSION AUTHORIZATION
_________________________________________________________________
Data Types and Functions
* New extra_float_digits server parameter to control float precision
display (Pedro Ferreira, Tom)
* Allow +1300 as a numeric timezone specifier, for FJST (Tom)
* Remove rarely used oidrand(), oidsrand(), and userfntest()
functions (Neil)
* Add md5() function to main server, already in /contrib/pgcrypto
(Joe)
* Increase date range of timestamp (John Cochran)
* Change EXTRACT(EPOCH FROM timestamp) so timestamp without time
zone is assumed to be in local time, not GMT (Tom)
* Trap division by zero in case the operating system doesn't prevent
it (Tom)
* Change the NUMERIC data type internally to base 10000 (Tom)
* New hostmask() function (Greg Wickham)
* Fixes for to_char() (Karel)
* Allow functions that can take any argument data type and return
any data type, using ANYELEMENT and ANYARRAY (Joe)
* Arrays may now be specified as ARRAY[1,2,3],
ARRAY[['a','b'],['c','d']], or ARRAY[ARRAY[ARRAY[2]]] (Joe)
* Allow proper comparisons for arrays (Joe)
* Allow array concatenation with '||' (Joe)
* Allow indexes on array columns, and used in ORDER BY and DISTINCT
(Joe)
* Allow WHERE qualification 'expr >oper< ANY/SOME/ALL (array-expr)'
(Joe)
* Allow polymorphic SQL functions (Joe)
* New array functions array_append(), array_cat(), array_lower(),
array_prepend(), array_to_string(), array_upper(),
string_to_array() (Joe)
* Allow user defined aggregates to use polymorphic functions (Joe)
* Allow polymorphic user defined aggregates (Joe)
* Allow assignments to empty arrays (Joe)
* Allow 60 in seconds fields of timestamp, time, interval input
values (Tom)
* Allow CIDR data type to be cast to text (Tom)
* Allow the creation of special LIKE indexes for non-C locales
(Peter)
* Disallow invalid timezone names (Tom)
* Trim trailing spaces when CHAR() data is cast to VARCHAR or TEXT
(Tom)
* Make FLOAT(p) measure the precision p in bits, not decimal digits
(Tom)
* Add IPv6 support to the inet and cidr data types (Michael Graff)
* Add family() function to report whether address is IPv4 or IPv6
(Michael Graff)
* Have SHOW DATESTYLE generate output similar to that used by SET
DATESTYLE (Tom)
* Change DATESTYLE to output its value in a more common format (Tom)
* Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL
convention for the sign of timezone offsets, ie, positive is east
from UTC (Tom)
* Fix date_trunc('quarter',...) (B?jthe Zolt?n)
* Make initcap() more compatible with Oracle (Mike Nolan)
* Allow only DateStyle field order for date values not in ISO format
(Greg)
* Add new DateStyle values MDY, DMY, and YMD, honor US and European
for backward compatibility (Tom)
* 'now' will no longer work as a column default, use now() (change
required for prepared statements) (Tom)
* Assume NaN value to be larger than any other value in MIN()/MAX()
(Tom)
* Prevent interval from suppressing ':00' seconds display
* New pg_get_triggerdef(prettyprint) and pg_constraint_is_visible()
functions
* Allow time to be specified as '040506' or '0405' (Tom)
_________________________________________________________________
Server-side Languages
* Prevent PL/pgSQL crash when RETURN NEXT is used on a zero-row
record var. (Tom)
* Make PL/python's spi_execute interface handle NULLs properly
(Andrew Bosma)
* Allow PL/pgSQL to declare variables of composite types without
%ROWTYPE (Tom)
* Fix PL/python _quote() function to handle big integers (?)
* Make PL/python an untrusted language, now called plpythonu (Kevin
Jacobs, Tom)
* Allow polymorphic PL/pgSQL functions (Tom, Joe)
* Improved compiled function caching mechanism in PL/pgSQL with full
support for polymorphism (Joe)
* Add new $0 parameter in PL/pgSQL representing the function's
actual return type (Joe)
* Allow pltcl and plpython use the same trigger on multiple tables
(Tom)
* Fixed PL/Tcl's spi_prepare to accept full qualified type names in
the parameter type list (Jan)
_________________________________________________________________
Psql
* Add "\pset pager always" to always use pager (Greg)
* Improve tab completion (Rod, Ross Reedstrom, Ian Barwick)
* Reorder \? help into groupings (Harald Armin Massa, Bruce)
* Add schema, cast, and conversion backslash commands (Christopher)
* \encoding now changes based on client_encoding server variable
(Tom)
* Save edit history into readline history (Ross)
* Improve \d display (Christopher)
* Enhance HTML mode to be more standards-compliant (Greg)
* New '\set AUTOCOMMIT off' capability (Tom)
* New '\set VERBOSITY' to control error detail (Tom)
* New %T prompt string to show transaction status (Tom)
_________________________________________________________________
Libpq
* Allow PQcmdTuples() to return row counts for MOVE and FETCH (Neil)
* Add PQfreemem() for freeing memory on Win32, suggest for NOTIFY
(Bruce)
* Document service capability, and add sample file (Bruce)
* Make PQsetdbLogin() have the same defaults as PQconnectdb() (Tom)
* Allow libpq to cleanly fail when result sets are too large (Tom)
* Improve performance of PGunescapeBytea() (Ben Lamb)
* Allow thread-safe libpq with --enable-thread-safety (Lee Kindness,
Philip Yarra)
* Allow pqInternalNotice() to accept a format string and args
instead of just a preformatted message (Tom, Sean Chittenden)
* Allow control SSL negotiation with sslmode values "disable",
"allow", "Prefer", and "require" (Jon Jensen)
* Allow new error codes and levels of text (Tom)
* Allow access to the underlying table and column of a query result
(Tom)
* Allow access to the current transaction status (Tom)
* Add ability to pass binary data directly to the backend (Tom)
* Add PQexecPrepared() and PQsendQueryPrepared() functions which
perform Bind/Execute of previously prepared statements (Tom)
_________________________________________________________________
JDBC
* Allow setNull on updateable resultsets
* Allow executeBatch on a prepared statement (Barry)
* Support SSL connections (Barry)
* Handle schema names in result sets (Paul Sorenson)
* Add refcursor support (Nic Ferrier)
_________________________________________________________________
Miscellaneous Interfaces
* Prevent possible memory leak or core dump during libpgtcl shutdown
(Tom)
* Add ecpg Informix compatibility (Michael)
* Add ecpg DECIMAL type that is fixed length, for Informix (Michael)
* Allow thread-safe ecpg with --enable-thread-safety (Lee Kindness,
Bruce)
* Move python client interface to http://www.pygresql.org (Marc)
_________________________________________________________________
Source Code
* Prevent need for separate platform geometry regression result
files (Tom)
* Improved PPC locking primitive (Reinhard Max)
* Embed LD_LIBRARY_PATH used for build process into binaries (Billy)
* New palloc0 to allocate and clear memory (Bruce)
* Fix locking code for s390x CPU (64-bit) (Tom)
* Allow OpenBSD to use local ident credentials (William Ahern)
* Make query plan trees read-only to executor (Tom)
* Add Darwin startup scripts (David Wheeler)
* Allow libpq to compile with Borland C++ compiler (Lester Godwin,
Karl Waclawek)
* Use our own version of getopt_long() if needed (Peter)
* Convert administration scripts to C (Peter)
* Bison >=1.85 is now required for grammar changes
* Merge documentation into one book (Peter)
* Add Win32 compatibility functions (Bruce)
* Allow client interfaces to compile under MinGW/Win32 (Bruce)
* New ereport() function for error reporting (Tom)
* Support Intel Linux compiler (Peter)
* Improve Linux startup scripts (Slawomir Sudnik, Darko Prenosil)
* Add support for AMD Opteron and Itanium (Jeffrey W. Baker, Bruce)
* Remove configure --enable-recode
* Generate a compile error if spinlock code is not found (Bruce)
_________________________________________________________________
Contrib
* Change dbmirror license to BSD
* Improve earthdistance (Bruno Wolff III)
* Portability improvements to pgcrypto (Marko Kreen)
* Prevent xml crash (John Gray, Michael Richards)
* Update oracle
* Update mysql
* Update cube (Bruno Wolff III)
* Update earthdistance to use cube (Bruno Wolff III)
* Update btree_gist (Oleg)
* New tsearch2 full-text search module (Oleg, Teodor)
* Add hashed based crosstab function to tablefuncs (Joe)
* Add serial column to order connectby() siblings in tablefuncs
(Nabil Sayegh,Joe)
* Add named persistent connections to dblink (Shridhar Daithanka)
* New pg_autovacuum allows automatic VACUUM (Matthew T. O'Connor)
* Allow pgbench to honor PGHOST, PGPORT, PGUSER env. variables
(Tatsuo)
* Improve intarray (Teodor Sigaev)
* Improve pgstattuple (Rod)
* Fix bug in metaphone() in fuzzystrmatch
* Improve adddepend (Rod)
* Update spi/timetravel (B?jthe Zolt?n)
* Fix dbase -s option and improve non-ASCII handling (Thomas
Behr,M?rcio Smiderle)
* Remove array module because features now included by default (Joe)
_________________________________________________________________
Other Uncategorized
* EXTRACT(TIMEZONE) and "SET/SHOW TIMEZONE " now follow SQL sign
convention (positive = east of UTC)
* "DATESTYLE" can now be set to DMY, YMD, or MDY to specify input
field order
* Input date order must now be YYYY-MM-DD (with 4-digit year) or
match DATESTYLE
* Output of "SHOW DATESTYLE" is now in the same format accepted by
"SET DATESTYLE"
* PL/Python is now an untrusted language, and is renamed to
plpythonu
* Dollar sign ($) is no longer allowed in operator names
* Dollar sign ($) can be a non-first character in identifiers
* Precision in FLOAT(p) is now interpreted as bits, not decimal
digits
* Functional indexes have been generalized into expressional indexes
* CHAR(n) to TEXT conversion automatically strips trailing blanks
* Pattern matching operations can use indexes regardless of locale
* New frontend/backend protocol supports many long-requested
features
* "SET AUTOCOMMIT TO OFF" is no longer supported; psql has an
AUTOCOMMIT variable
* Reimplementation of NUMERIC datatype for more speed
* New regular expression package, many more regexp features (most of
Perl5)
* Can now do " EXPLAIN" ... "EXECUTE" to see plan used for a
prepared query
* Explicit "JOIN"s no longer constrain query plan, unless
"JOIN_COLLAPSE_LIMIT = 1"
* Performance of "foo IN (SELECT ...)" queries has been considerably
improved
* "FETCH 0" now re-fetches cursor's current row, per SQL spec
* Revised executor state representation; plan trees are read-only to
executor now
* Information schema
* Domains now support "CHECK" constraints
* psql backslash commands for listing conversions, casts, and
schemas
* "TRUNCATE TABLE" is transaction-safe
* "CLUSTER" can re-cluster a previously clustered table, or all such
tables
* Statement-level triggers
* System can use either hash- or sort-based strategy for grouped
aggregation
* "ON COMMIT" options for temp tables
* extra_float_digits option allows pg_dump to dump float data
accurately
* Long options for psql and pg_dump are now available on all
platforms
* Read-only transactions
* Object owners can allow grantees to grant the privilege to others
(grant option)
* Added "contrib" module for pg_autovacuum which monitors inserts
and deletes, and does "ANALYZE" or " VACUUM ANALYZE " when
quantities exceed specified thresholds.
_________________________________________________________________
Release 7.3.4
Release date: 2003-07-24
This has a variety of fixes from 7.3.3.
_________________________________________________________________
Migration to version 7.3.4
A dump/restore is *not* required for those running 7.3.*.
_________________________________________________________________
Changes
* Repair breakage in timestamp-to-date conversion for dates before
2000
* Prevent rare possibility of server startup failure (Tom)
* Fix bugs in interval-to-time conversion (Tom)
* Add constraint names in a few places in pg_dump (Rod)
* Improve performance of functions with many parameters (Tom)
* Fix to_ascii() buffer overruns (Tom)
* Prevent restore of database comments from throwing an error (Tom)
* Work around buggy strxfrm() present in some Solaris releases (Tom)
* Properly escape jdbc setObject() strings to improve security
(Barry)
_________________________________________________________________
Release 7.3.3
Release date: 2003-05-22
This release contains of variety of fixes for version 7.3.2.
_________________________________________________________________
Migration to version 7.3.3
A dump/restore is *not* required for those running version 7.3.*.
_________________________________________________________________
Changes
* Repair sometimes-incorrect computation of StartUpID after a crash
* Avoid slowness with lots of deferred triggers in one transaction
(Stephan)
* Don't lock referenced row when "UPDATE" doesn't change foreign
key's value (Jan)
* Use "-fPIC" not "-fpic" on Sparc (Tom Callaway)
* Repair lack of schema-awareness in contrib/reindexdb
* Fix contrib/intarray error for zero-element result array (Teodor)
* Ensure createuser script will exit on control-C (Oliver)
* Fix errors when the type of a dropped column has itself been
dropped
* "CHECKPOINT" does not cause database panic on failure in
noncritical steps
* Accept 60 in seconds fields of timestamp, time, interval input
values
* Issue notice, not error, if TIMESTAMP, TIME, or INTERVAL precision
too large
* Fix abstime-to-time cast function (fix is not applied unless you
initdb)
* Fix pg_proc entry for timestampt_izone (fix is not applied unless
you initdb)
* Make EXTRACT(EPOCH FROM timestamp without time zone) treat input
as local time
* "'now'::timestamptz" gave wrong answer if timezone changed earlier
in transaction
* HAVE_INT64_TIMESTAMP code for time with timezone overwrote its
input
* Accept "GLOBAL TEMP/TEMPORARY" as a synonym for "TEMPORARY"
* Avoid improper schema-permissions-check failure in foreign-key
triggers
* Fix bugs in foreign-key triggers for "SET DEFAULT" action
* Fix incorrect time-qual check in row fetch for "UPDATE" and
"DELETE" triggers
* Foreign-key clauses were parsed but ignored in "ALTER TABLE ADD
COLUMN"
* Fix createlang script breakage for case where handler function
already exists
* Fix misbehavior on zero-column tables in pg_dump, COPY, ANALYZE,
other places
* Fix misbehavior of func_error() on type names containing '%'
* Fix misbehavior of replace() on strings containing '%'
* Regular-expression patterns containing certain multibyte
characters failed
* Account correctly for "NULL"s in more cases in join size
estimation
* Avoid conflict with system definition of isblank() function or
macro
* Fix failure to convert large code point values in EUC_TW
conversions (Tatsuo)
* Fix error recovery for SSL_read/SSL_write calls
* Don't do early constant-folding of type coercion expressions
* Validate page header fields immediately after reading in any page
* Repair incorrect check for ungrouped variables in unnamed joins
* Fix buffer overrun in to_ascii (Guido Notari)
* contrib/ltree fixes (Teodor)
* Fix core dump in deadlock detection on machines where char is
unsigned
* Avoid running out of buffers in many-way indexscan (bug introduced
in 7.3)
* Fix planner's selectivity estimation functions to handle domains
properly
* Fix dbmirror memory-allocation bug (Steven Singer)
* Prevent infinite loop in ln(numeric) due to roundoff error
* "GROUP BY" got confused if there were multiple equal GROUP BY
items
* Fix bad plan when inherited "UPDATE"/"DELETE" references another
inherited table
* Prevent clustering on incomplete (partial or non-NULL-storing)
indexes
* Service shutdown request at proper time if it arrives while still
starting up
* Fix left-links in temporary indexes (could make backwards scans
miss entries)
* Fix incorrect handling of client_encoding setting in
postgresql.conf (Tatsuo)
* Fix failure to respond to "pg_ctl stop -m fast" after
Async_NotifyHandler runs
* Fix SPI for case where rule contains multiple statements of the
same type
* Fix problem with checking for wrong type of access permission in
rule query
* Fix problem with "EXCEPT" in "CREATE RULE"
* Prevent problem with dropping temp tables having serial columns
* Fix replace_vars_with_subplan_refs failure in complex views
* Fix regexp slowness in single-byte encodings (Tatsuo)
* Allow qualified type names in "CREATE CAST" and " DROP CAST"
* Accept SETOF type[], which formerly had to be written SETOF _type
* Fix pg_dump core dump in some cases with procedural languages
* Force ISO datestyle in pg_dump output, for portability (Oliver)
* pg_dump failed to handle error return from lo_read (Oleg Drokin)
* pg_dumpall failed with groups having no members (Nick Eskelinen)
* pg_dumpall failed to recognize --globals-only switch
* pg_restore failed to restore blobs if -X disable-triggers is
specified
* Repair intrafunction memory leak in plpgsql
* pltcl's "elog" command dumped core if given wrong parameters (Ian
Harding)
* plpython used wrong value of atttypmod (Brad McLean)
* Fix improper quoting of boolean values in Python interface
(D'Arcy)
* Added addDataType() method to PGConnection interface for JDBC
* Fixed various problems with updateable ResultSets for JDBC (Shawn
Green)
* Fixed various problems with DatabaseMetaData for JDBC (Kris Jurka,
Peter Royal)
* Fixed problem with parsing table ACLs in JDBC
* Better error message for character set conversion problems in JDBC
_________________________________________________________________
Release 7.3.2
Release date: 2003-02-04
This release contains a variety of fixes for version 7.3.1.
_________________________________________________________________
Migration to version 7.3.2
A dump/restore is *not* required for those running version 7.3.*.
_________________________________________________________________
Changes
* Restore creation of OID column in CREATE TABLE AS / SELECT INTO
* Fix pg_dump core dump when dumping views having comments
* Dump DEFERRABLE/INITIALLY DEFERRED constraints properly
* Fix UPDATE when child table's column numbering differs from parent
* Increase default value of max_fsm_relations
* Fix problem when fetching backwards in a cursor for a single-row
query
* Make backward fetch work properly with cursor on SELECT DISTINCT
query
* Fix problems with loading pg_dump files containing contrib/lo
usage
* Fix problem with all-numeric user names
* Fix possible memory leak and core dump during disconnect in
libpgtcl
* Make plpython's spi_execute command handle nulls properly (Andrew
Bosma)
* Adjust plpython error reporting so that its regression test passes
again
* Work with bison 1.875
* Handle mixed-case names properly in plpgsql's %type (Neil)
* Fix core dump in pltcl when executing a query rewritten by a rule
* Repair array subscript overruns (per report from Yichen Xie)
* Reduce MAX_TIME_PRECISION from 13 to 10 in floating-point case
* Correctly case-fold variable names in per-database and per-user
settings
* Fix coredump in plpgsql's RETURN NEXT when SELECT into record
returns no rows
* Fix outdated use of pg_type.typprtlen in python client interface
* Correctly handle fractional seconds in timestamps in JDBC driver
* Improve performance of getImportedKeys() in JDBC
* Make shared-library symlinks work standardly on HPUX (Giles)
* Repair inconsistent rounding behavior for timestamp, time,
interval
* SSL negotiation fixes (Nathan Mueller)
* Make libpq's ~/.pgpass feature work when connecting with
PQconnectDB
* Update my2pg, ora2pg
* Translation updates
* Add casts between types lo and oid in contrib/lo
* fastpath code now checks for privilege to call function
_________________________________________________________________
Release 7.3.1
Release date: 2002-12-18
This release contains a variety of fixes for version 7.3.
_________________________________________________________________
Migration to version 7.3.1
A dump/restore is *not* required for those running version 7.3.
However, it should be noted that the main PostgreSQL interface
library, libpq, has a new major version number for this release, which
may require recompilation of client code in certain cases.
_________________________________________________________________
Changes
* Fix a core dump of COPY TO when client/server encodings don't
match (Tom)
* Allow pg_dump to work with pre-7.2 servers (Philip)
* contrib/adddepend fixes (Tom)
* Fix problem with deletion of per-user/per-database config settings
(Tom)
* contrib/vacuumlo fix (Tom)
* Allow 'password' encryption even when pg_shadow contains MD5
passwords (Bruce)
* contrib/dbmirror fix (Steven Singer)
* Optimizer fixes (Tom)
* contrib/tsearch fixes (Teodor Sigaev, Magnus)
* Allow locale names to be mixed case (Nicolai Tufar)
* Increment libpq library's major version number (Bruce)
* pg_hba.conf error reporting fixes (Bruce, Neil)
* Add SCO Openserver 5.0.4 as a supported platform (Bruce)
* Prevent EXPLAIN from crashing server (Tom)
* SSL fixes (Nathan Mueller)
* Prevent composite column creation via ALTER TABLE (Tom)
_________________________________________________________________
Release 7.3
Release date: 2002-11-27
_________________________________________________________________
Overview
Major changes in this release:
Schemas
Schemas allow users to create objects in separate namespaces,
so two people or applications can have tables with the same
name. There is also a public schema for shared tables.
Table/index creation can be restricted by removing permissions
on the public schema.
Drop Column
PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
functionality.
Table Functions
Functions returning multiple rows and/or multiple columns are
now much easier to use than before. You can call such a "table
function" in the SELECT FROM clause, treating its output like a
table. Also, PL/pgSQL functions can now return sets.
Prepared Queries
PostgreSQL now supports prepared queries, for improved
performance.
Dependency Tracking
PostgreSQL now records object dependencies, which allows
improvements in many areas. "DROP" statements now take either
CASCADE or RESTRICT to control whether dependent objects are
also dropped.
Privileges
Functions and procedural languages now have privileges, and
functions can be defined to run with the privileges of their
creator.
Internationalization
Both multibyte and locale support are now always enabled.
Logging
A variety of logging options have been enhanced.
Interfaces
A large number of interfaces have been moved to
http://gborg.postgresql.org where they can be developed and
released independently.
Functions/Identifiers
By default, functions can now take up to 32 parameters, and
identifiers can be up to 63 bytes long. Also, OPAQUE is now
deprecated: there are specific "pseudo-datatypes" to represent
each of the former meanings of OPAQUE in function argument and
result types.
_________________________________________________________________
Migration to version 7.3
A dump/restore using pg_dump is required for those wishing to migrate
data from any previous release. If your application examines the
system catalogs, additional changes will be required due to the
introduction of schemas in 7.3; for more information, see:
http://developer.postgresql.org/~momjian/upgrade_tips_7.3.
Observe the following incompatibilities:
* Pre-6.3 clients are no longer supported.
* "pg_hba.conf" now has a column for the user name and additional
features. Existing files need to be adjusted.
* Several "postgresql.conf" logging parameters have been renamed.
* LIMIT #,# has been disabled; use LIMIT # OFFSET #.
* "INSERT" statements with column lists must specify a value for
each specified column. For example, INSERT INTO tab (col1, col2)
VALUES ('val1') is now invalid. It's still allowed to supply fewer
columns than expected if the "INSERT" does not have a column list.
* serial columns are no longer automatically UNIQUE; thus, an index
will not automatically be created.
* A "SET" command inside an aborted transaction is now rolled back.
* "COPY" no longer considers missing trailing columns to be null.
All columns need to be specified. (However, one may achieve a
similar effect by specifying a column list in the "COPY" command.)
* The data type timestamp is now equivalent to timestamp without
time zone, instead of timestamp with time zone.
* Pre-7.3 databases loaded into 7.3 will not have the new object
dependencies for serial columns, unique constraints, and foreign
keys. See the directory "contrib/adddepend/" for a detailed
description and a script that will add such dependencies.
* An empty string ('') is no longer allowed as the input into an
integer field. Formerly, it was silently interpreted as 0.
_________________________________________________________________
Changes
Server Operation
* Add pg_locks view to show locks (Neil)
* Security fixes for password negotiation memory allocation (Neil)
* Remove support for version 0 FE/BE protocol (PostgreSQL 6.2 and
earlier) (Tom)
* Reserve the last few backend slots for superusers, add parameter
superuser_reserved_connections to control this (Nigel J. Andrews)
_________________________________________________________________
Performance
* Improve startup by calling localtime() only once (Tom)
* Cache system catalog information in flat files for faster startup
(Tom)
* Improve caching of index information (Tom)
* Optimizer improvements (Tom, Fernando Nasser)
* Catalog caches now store failed lookups (Tom)
* Hash function improvements (Neil)
* Improve performance of query tokenization and network handling
(Peter)
* Speed improvement for large object restore (Mario Weilguni)
* Mark expired index entries on first lookup, saving later heap
fetches (Tom)
* Avoid excessive NULL bitmap padding (Manfred Koizar)
* Add BSD-licensed qsort() for Solaris, for performance (Bruce)
* Reduce per-row overhead by four bytes (Manfred Koizar)
* Fix GEQO optimizer bug (Neil Conway)
* Make WITHOUT OID actually save four bytes per row (Manfred Koizar)
* Add default_statistics_target variable to specify ANALYZE buckets
(Neil)
* Use local buffer cache for temporary tables so no WAL overhead
(Tom)
* Improve free space map performance on large tables (Stephen
Marshall, Tom)
* Improved WAL write concurrency (Tom)
_________________________________________________________________
Privileges
* Add privileges on functions and procedural languages (Peter)
* Add OWNER to CREATE DATABASE so superusers can create databases on
behalf of unprivileged users (Gavin Sherry, Tom)
* Add new object permission bits EXECUTE and USAGE (Tom)
* Add SET SESSION AUTHORIZATION DEFAULT and RESET SESSION
AUTHORIZATION (Tom)
* Allow functions to be executed with the privilege of the function
owner (Peter)
_________________________________________________________________
Server Configuration
* Server log messages now tagged with LOG, not DEBUG (Bruce)
* Add user column to pg_hba.conf (Bruce)
* Have log_connections output two lines in log file (Tom)
* Remove debug_level from postgresql.conf, now server_min_messages
(Bruce)
* New ALTER DATABASE/USER ... SET command for per-user/database
initialization (Peter)
* New parameters server_min_messages and client_min_messages to
control which messages are sent to the server logs or client
applications (Bruce)
* Allow pg_hba.conf to specify lists of users/databases separated by
commas, group names prepended with +, and file names prepended
with @ (Bruce)
* Remove secondary password file capability and pg_password utility
(Bruce)
* Add variable db_user_namespace for database-local user names
(Bruce)
* SSL improvements (Bear Giles)
* Make encryption of stored passwords the default (Bruce)
* Allow pg_statistics to be reset by calling pg_stat_reset()
(Christopher)
* Add log_duration parameter (Bruce)
* Rename debug_print_query to log_statement (Bruce)
* Rename show_query_stats to show_statement_stats (Bruce)
* Add param log_min_error_statement to print commands to logs on
error (Gavin)
_________________________________________________________________
Queries
* Make cursors insensitive, meaning their contents do not change
(Tom)
* Disable LIMIT #,# syntax; now only LIMIT # OFFSET # supported
(Bruce)
* Increase identifier length to 63 (Neil, Bruce)
* UNION fixes for merging >= 3 columns of different lengths (Tom)
* Add DEFAULT keyword to INSERT, e.g., INSERT ... (..., DEFAULT,
...) (Rod)
* Allow views to have default values using ALTER COLUMN ... SET
DEFAULT (Neil)
* Fail on INSERTs with column lists that don't supply all column
values, e.g., INSERT INTO tab (col1, col2) VALUES ('val1'); (Rod)
* Fix for join aliases (Tom)
* Fix for FULL OUTER JOINs (Tom)
* Improve reporting of invalid identifier and location (Tom, Gavin)
* Fix OPEN cursor(args) (Tom)
* Allow 'ctid' to be used in a view and currtid(viewname) (Hiroshi)
* Fix for CREATE TABLE AS with UNION (Tom)
* SQL99 syntax improvements (Thomas)