11 ------------------------------------------------------------------------
22 Release Notes
33 ------------------------------------------------------------------------
4+
5+ Release 7.0.1
6+
7+ This is basically a cleanup release for 7.0.1
8+
9+ Migration to v7.0.1
10+
11+ A dump/restore is not required for those running 7.0.
12+
13+ Changes
14+ -------
15+ Fix many CLUSTER failures (Tom)
16+ Allow ALTER TABLE RENAME works on indexes (Tom)
17+ Fix plpgsql to handle datetime->timestamp and timespan->interval (Bruce)
18+ New configure --with-setproctitle switch to use setproctitle() (Marc, Bruce)
19+ Fix the off by one errors in ResultSet from 6.5.3, and more.
20+ jdbc ResultSet fixes (Joseph Shraibman)
21+ optimizer tunings (Tom)
22+ Fix create user for pgaccess
23+ Fix for UNLISTEN failure
24+ IRIX fixes (David Kaelbling)
25+ QNX fixes (Andreas Kardos)
26+ Reduce COPY IN lock level (Tom)
27+ Change libpqeasy to use PQconnectdb() style parameters (Bruce)
28+ Fix pg_dump to handle OID indexes (Tom)
29+ Fix small memory leak (Tom)
30+ Solaris fix for createdb/dropdb
31+ Fix for non-blocking connections (Alfred Perlstein)
32+ Fix improper recovery after RENAME TABLE failures (Tom)
33+ Copy pg_ident.conf.sample into /lib directory in install (Bruce)
34+
35+
36+ ------------------------------------------------------------------------
37+ Release 7.0
38+ Release Notes
39+ ------------------------------------------------------------------------
440
541Release 7.0
642
@@ -35,7 +71,7 @@ Migration to v7.0
3571 data from any previous release. For those upgrading from 6.5.*, you
3672 can use pg_upgrade to upgrade to this release.
3773
38- Detailed Change List
74+
3975Bug Fixes
4076---------
4177Prevent function calls with more than maximum number of arguments (Tom)
@@ -362,6 +398,10 @@ Fixes for Alpha compiles
362398New multibyte encodings
363399
364400
401+ ------------------------------------------------------------------------
402+ Release 6.5.3
403+ Release Notes
404+ ------------------------------------------------------------------------
365405
366406Release 6.5.3
367407
@@ -372,11 +412,12 @@ Migration to v6.5.3
372412
373413A dump/restore is not required for those running 6.5.*.
374414
375- Detailed Change List
376-
415+ Changes
416+ -------
377417Updated version of pgaccess 0.98
378418NT-specific patch
379419
420+
380421 ------------------------------------------------------------------------
381422 Release 6.5.2
382423 Release Notes
@@ -391,8 +432,8 @@ Migration to v6.5.2
391432
392433A dump/restore is not required for those running 6.5.*.
393434
394- Detailed Change List
395-
435+ Changes
436+ -------
396437subselect+CASE fixes(Tom)
397438Add SHLIB_LINK setting for solaris_i386 and solaris_sparc ports(Daren Sefcik)
398439Fixes for CASE in WHERE join clauses(Tom)
@@ -418,6 +459,7 @@ Repair logic error in LIKE: should not return LIKE_ABORT
418459Repair incorrect cleanup of heap memory allocation during transaction abort(Tom)
419460Updated version of pgaccess 0.98
420461
462+
421463 ------------------------------------------------------------------------
422464Release Notes Release 6.5.1
423465 Release Notes
@@ -432,8 +474,8 @@ Migration to v6.5.1
432474
433475A dump/restore is not required for those running 6.5.
434476
435- Detailed Change List
436-
477+ Changes
478+ -------
437479Add NT README file
438480Portability fixes for linux_ppc, Irix, linux_alpha, OpenBSD, alpha
439481Remove QUERY_LIMIT, use SELECT...LIMIT
@@ -458,6 +500,7 @@ Fixed glitches affecting GROUP BY in subselects(Tom)
458500Fix some compiler warnings (Tomoaki Nishiyama)
459501Add Win1250 (Czech) support (Pavel Behal)
460502
503+
461504 ------------------------------------------------------------------------
462505Release 6.5.2 Release 6.5
463506 Release Notes
@@ -576,7 +619,6 @@ These inconveniences will disappear in the future when the ability to read
576619dirty (uncommitted) data (regardless of isolation level) and true
577620referential integrity will be implemented.
578621
579- Detailed Change List
580622
581623Bug Fixes
582624---------
@@ -755,10 +797,11 @@ Migration to v6.4.2
755797
756798A dump/restore is not required for those running 6.4.*.
757799
758- Detailed Change List
759-
800+ Changes
801+ -------
760802Fix for datetime constant problem on some platforms(Thomas)
761803
804+
762805 ------------------------------------------------------------------------
763806Release 6.5 Release 6.4.1
764807 Release Notes
@@ -773,8 +816,8 @@ Migration to v6.4.1
773816
774817A dump/restore is not required for those running 6.4.
775818
776- Detailed Change List
777-
819+ Changes
820+ -------
778821Add pg_dump -N flag to force double quotes around identifiers. This is
779822 the default(Thomas)
780823Fix for NOT in where clause causing crash(Bruce)
@@ -806,6 +849,7 @@ Add routines to help with single-byte (internal) character type(Thomas)
806849Compilation of libpq for Win32 fixes(Magnus)
807850Upgrade to PyGreSQL 2.2(D'Arcy)
808851
852+
809853 ------------------------------------------------------------------------
810854Release 6.4.2 Release 6.4
811855 Release Notes
@@ -856,7 +900,6 @@ Migration to v6.4
856900A dump/restore using pg_dump or pg_dumpall is required for those wishing to
857901migrate data from any previous release of Postgres.
858902
859- Detailed Change List
860903
861904Bug Fixes
862905---------
@@ -1051,6 +1094,7 @@ smarter perl configuration(Brook)
10511094configure uses supplied install-sh if no install script found(Tom)
10521095new Makefile.shlib for shared library configuration(Tom)
10531096
1097+
10541098 ------------------------------------------------------------------------
10551099Release 6.4.1 Release 6.3.2
10561100 Release Notes
@@ -1077,7 +1121,6 @@ re-link any custom applications that use Postgres libraries.
10771121For upgrades from pre-v6.3 installations, refer to the installation and
10781122migration instructions for v6.3.
10791123
1080- Detailed Change List
10811124
10821125Changes
10831126-------
@@ -1100,6 +1143,7 @@ Remove DISTDIR(Bruce)
11001143Makefile dependency cleanup(Jeroen van Vianen)
11011144ASSERT fixes(Bruce)
11021145
1146+
11031147 ------------------------------------------------------------------------
11041148Release 6.4 Release 6.3.1
11051149 Release Notes
@@ -1125,7 +1169,6 @@ applications that use Postgres libraries.
11251169For upgrades from pre-v6.3 installations, refer to the installation and
11261170migration instructions for v6.3.
11271171
1128- Detailed Change List
11291172
11301173Changes
11311174-------
@@ -1157,6 +1200,7 @@ Fix for text arrays containing quotes(Doug Gibson)
11571200Solaris compile fix(Albert Chin-A-Young)
11581201Better identify tcl and tk libs and includes(Bruce)
11591202
1203+
11601204 ------------------------------------------------------------------------
11611205Release 6.3.2 Release 6.3
11621206 Release Notes
@@ -1245,7 +1289,6 @@ Migration to v6.3
12451289A dump/restore using pg_dump or pg_dumpall is required for those wishing to
12461290migrate data from any previous release of Postgres.
12471291
1248- Detailed Change List
12491292
12501293Bug Fixes
12511294---------
@@ -1412,6 +1455,7 @@ Add string functions to regression suite(Thomas)
14121455Expand a few function names formerly truncated to 16 characters(Thomas)
14131456Remove un-needed malloc() calls and replace with palloc()(Bruce)
14141457
1458+
14151459 ------------------------------------------------------------------------
14161460Release 6.3.1 Release 6.2.1
14171461 Release Notes
@@ -1449,10 +1493,9 @@ psql to update the existing system table:
14491493
14501494This will need to be done to every existing database, including template1.
14511495
1452- Detailed Change List
14531496
1454- Changes in this release
1455- -----------------------
1497+ Changes
1498+ -------
14561499Allow TIME and TYPE column names(Thomas)
14571500Allow larger range of true/false as boolean values(Thomas)
14581501Support output of "now" and "current"(Thomas)
@@ -1465,6 +1508,7 @@ Fix for specifying a column twice in ORDER/GROUP BY(Vadim)
14651508Documented new libpq function to return affected rows, PQcmdTuples(Bruce)
14661509Trigger function for inserting user names for INSERT/UPDATE(Brook Milligan)
14671510
1511+
14681512 ------------------------------------------------------------------------
14691513Release 6.3 Release 6.2
14701514 Release Notes
@@ -1488,7 +1532,6 @@ Migration from v1.x to v6.2
14881532Those migrating from earlier 1.* releases should first upgrade to 1.09
14891533because the COPY output format was improved from the 1.02 release.
14901534
1491- Detailed Change List
14921535
14931536Bug Fixes
14941537---------
@@ -1599,6 +1642,7 @@ Massive commit to run PGINDENT on all *.c and *.h files(Bruce)
15991642Files moved to /src/tools directory(Bruce)
16001643SPI and Trigger programming guides (Vadim & D'Arcy)
16011644
1645+
16021646 ------------------------------------------------------------------------
16031647Release 6.2.1 Release 6.1.1
16041648 Release Notes
@@ -1612,10 +1656,9 @@ This is a minor bug-fix release. A dump/reload is not required from v6.1,
16121656but is required from any release prior to v6.1. Refer to the release notes
16131657for v6.1 for more details.
16141658
1615- Detailed Change List
16161659
1617- Changes in this release
1618- -----------------------
1660+ Changes
1661+ -------
16191662fix for SET with options (Thomas)
16201663allow pg_dump/pg_dumpall to preserve ownership of all tables/objects(Bruce)
16211664new psql \connect option allows changing usernames without changing databases
@@ -1634,8 +1677,9 @@ Fix for Solaris assembler and include files(Yoshihiko Ichikawa)
16341677allow underscores in usernames(Bruce)
16351678pg_dumpall now returns proper status, portability fix(Bruce)
16361679
1680+
16371681 ------------------------------------------------------------------------
1638- Release 6.2 Release 6.1
1682+ Release 6.1
16391683 Release Notes
16401684 ------------------------------------------------------------------------
16411685
@@ -1682,7 +1726,6 @@ the database in 6.1.
16821726Those migrating from earlier 1.* releases should first upgrade to 1.09
16831727because the COPY output format was improved from the 1.02 release.
16841728
1685- Detailed Change List
16861729
16871730Bug Fixes
16881731---------
@@ -1779,8 +1822,9 @@ c++ include file cleanup(Bruce)
17791822warn about buggy flex(Bruce)
17801823DG-UX, Ultrix, Irix, AIX portability fixes
17811824
1825+
17821826 ------------------------------------------------------------------------
1783- Release 6.1.1 Release v6.0
1827+ Release v6.0
17841828 Release Notes
17851829 ------------------------------------------------------------------------
17861830
@@ -1799,7 +1843,6 @@ Migration from pre-v1.09 to v6.0
17991843Those migrating from earlier 1.* releases should first upgrade to 1.09
18001844because the COPY output format was improved from the 1.02 release.
18011845
1802- Detailed Change List
18031846
18041847Bug Fixes
18051848---------
@@ -1905,8 +1948,9 @@ Restructured object file generation/location(Bryan, Marc)
19051948Restructured port-specific file locations(Bryan, Marc)
19061949Unused/uninialized variables corrected
19071950
1951+
19081952 ------------------------------------------------------------------------
1909- Release 6.1 Release v1.09
1953+ Release v1.09
19101954 Release Notes
19111955 ------------------------------------------------------------------------
19121956
@@ -2001,8 +2045,9 @@ New Ports
20012045 * added BSDI 2.1 port
20022046 * added DGUX port
20032047
2048+
20042049 ------------------------------------------------------------------------
2005- Release v1.09 Release v1.01
2050+ Release v1.01
20062051 Release Notes
20072052 ------------------------------------------------------------------------
20082053
@@ -2138,8 +2183,9 @@ Bug fixes:
21382183 * psql now returns non-zero status on errors when using -c
21392184 * applied public patches 1-14
21402185
2186+
21412187 ------------------------------------------------------------------------
2142- Release v1.02 Release v1.0
2188+ Release v1.0
21432189 Release Notes
21442190 ------------------------------------------------------------------------
21452191
@@ -2187,8 +2233,9 @@ Bug fixes:
21872233 * btrees with multiple index never worked, now we tell you they don't
21882234 work when you try to use them
21892235
2236+
21902237 ------------------------------------------------------------------------
2191- Release v1.01 Postgres95 Beta 0.03
2238+ Postgres95 Beta 0.03
21922239 Release Notes
21932240 ------------------------------------------------------------------------
21942241
@@ -2302,8 +2349,9 @@ New utilities:
23022349New documentation:
23032350 * the user manual has been revised and libpq documentation added.
23042351
2352+
23052353 ------------------------------------------------------------------------
2306- Release v1.0 Postgres95 Beta 0.02
2354+ Postgres95 Beta 0.02
23072355 Release Notes
23082356 ------------------------------------------------------------------------
23092357
@@ -2346,16 +2394,17 @@ The following bugs have been fixed in postgres95-beta-0.02:
23462394 * wrong result using more than 1 aggregate in a SELECT
23472395
23482396 ------------------------------------------------------------------------
2349- Postgres95 Beta 0.03 Postgres95 Beta 0.01
2397+ Postgres95 Beta 0.01
23502398 Release Notes
23512399 ------------------------------------------------------------------------
23522400
23532401Postgres95 Beta 0.01
23542402
23552403Initial release.
23562404
2405+
23572406 ------------------------------------------------------------------------
2358- Postgres95 Beta 0.02 Timing Results
2407+ Timing Results
23592408 Release Notes
23602409Prev
23612410 ------------------------------------------------------------------------
@@ -2421,7 +2470,3 @@ v6.1
24212470 06:12 Pentium Pro 180, 32MB, EIDE, Linux 2.0.30, gcc 2.7.2 -O2 -m486
24222471 12:06 P-100, 48MB, Linux 2.0.29, gcc
24232472 39:58 Sparc IPC 32MB, Solaris 2.5, gcc 2.7.2.1 -O -g
2424-
2425- ------------------------------------------------------------------------
2426- Prev Home
2427- Postgres95 Beta 0.01