1- PostgreSQL 6.4Tue Sep 1 21:18:17 EDT 1998
1+ PostgreSQL 6.4Sat Oct 24 00:41:35 EDT 1998
22=========================================================
33
44A dump/restore is required for those wishing to migrate data from
5- previous releases of PostgreSQL.
5+ previous releases of PostgreSQL. You may also use the new pg_upgrade
6+ utility to avoid a dump/reload.
67
78Bug Fixes
89---------
@@ -21,12 +22,13 @@ Fix a bug in the oracle compatibility functions btrim() ltrim() and rtrim()
2122Fix for usernames longer than eight characters(Tom)
2223Fix for shared invalidation cache overflow(Massimo)
2324Prevent file descriptor leaks in failed COPY's(Bruce)
25+ Fix problem with username/passwords over 8 characters(Tom)
2426
2527Enhancements
2628------------
27- UpgradeECPG to 2.0, see src/interfaces/ecpc/ChangeLog(Michael)
29+ Upgradeecpg and ecpglib, see src/interfaces/ecpc/ChangeLog(Michael)
2830Show the index used in an explain(Zeugswetter)
29- Multi-byte awareness of many datadata types and functions(Tatsuo)
31+ Multi-byte awareness of many data types and functions, via configure (Tatsuo)
3032New configure --with-mb option(Tatsuo)
3133New initdb --pgencoding option(Tatsuo)
3234New createdb -E multibyte option(Tatsuo)
@@ -64,6 +66,7 @@ Pg_hba.conf now has a sameuser option in the database field
6466Make lo_unlink take oid param, not int4
6567New DISABLE_COMPLEX_MACRO for compilers that can't handle our macros(Bruce)
6668Libpgtcl now gets async notifies from libpq(Tom)
69+ libpgtcl cleanups(Tom)
6770New locale patch, see docs/README/locale(Oleg)
6871Fix for pg_dump so CONSTRAINT and CHECK syntax is correct(ccb)
6972New contrib/lo code for large object orphan removal(Peter)
@@ -74,8 +77,9 @@ Libpq can now be compiled on win32(Magnus)
7477Add PQsetdbLogin() in libpq
7578Two styles we agreed upon for database descriptors(Thomas)
7679New 8-byte integer type, checked by configure for OS support(Thomas)
80+ Better support for quited table/column names(Thomas)
7781Surround table and column names with double-quotes(Thomas) in generated
78- sql code to preserve case (SQL92 syntax)(Thomas)
82+
7983New libpqrequestCancel(Tom)
8084PQreset() now works with passwords(Tom)
8185Handle case of GROUP BY target list column number out of range(David)
@@ -118,9 +122,13 @@ New rewrite system fixes many problems with rules and views(Jan)
118122* Rules and views inherit the permissions on the creator
119123* No rules at the column level
120124* No UPDATE NEW/OLD rules
121- * Newpg_rule andpg_view system views
125+ * Newpg_tables, pg_indexes, pg_rules andpg_views system views
122126* Only a single action on SELECT rules
123127* Total rewrite overhaul, perhaps for 6.5
128+ * handle subselects
129+ * handle aggregates on views
130+ * handle insert into select from view works
131+ *
124132
125133System indexes are now multi-key(Bruce)
126134Oidint2, oidint4, and oidname types are removed(Bruce)
@@ -133,9 +141,27 @@ New setval() command to set sequence value(Massimo)
133141Auto-remove unix socket file on startup if no postmaster running(Massimo)
134142Conditional trace package(Massimo)
135143New UNLISTEN command(Massimo)
136- Psql nowcompiles under win32 using win32.mak(Magnus)
144+ Psqland libpq nowcompile under win32 using win32.mak(Magnus)
137145Lo_read no longer stores trailing NULL(Bruce)
138146Identifiers are now truncated to 31 characters internally(Bruce)
147+ Createuser options now availble on the command line
148+ PL/pgSQL backend programming language(Jan)
149+ Code for 64-bit integer supported added, configure tested, int8 type(Thomas)
150+ Prevent file descriptor leaf from failed COPY(Bruce)
151+ New pg_upgrade command(Bruce)
152+ Updated /contrib directories(Massimo)
153+ New CREATE TABLE DEFAULT VALUES statement available(Thomas)
154+ New INSERT INTO TABLE DEFAULT VALUES statement available(Thomas)
155+ New DECLARE and FETCH feature(Thomas)
156+ libpq's internal structures now not exported(Tom)
157+ Allow up to 8 key indexes(Bruce)
158+ Remove ARCHIVE keyword, that is no longer used(Thomas)
159+ pg_dump -n flag to supress quotes around indentifiers
160+ disable system columns for views(Jan)
161+ net INET and CIDR types for network addresses(TomH, Paul)
162+ no more double quotes in psql output
163+ pg_dump now dumps views(Terry)
164+ new SET QUERY_LIMIT(Tatsuo,Jan)
139165
140166Source Tree Changes
141167-------------------
@@ -155,11 +181,18 @@ Update backend flowchart in tools/backend(Bruce)
155181Change atttypmod from int16 to int32(Bruce, Tom)
156182Getrusage() fix for platforms that do not have it(Tom)
157183Add PGUSER to libpq man page
158- Ns32k platform fixes(Phil Nelson)
184+ NS32K platform fixes(Phil Nelson, John Buller )
159185Sco 7/UnixWare 2.x fixes(Billy,others)
160186Sparc/Solaris 2.5 fixes(Ryan)
161187Pgbuiltin.3 is obsolete, move to doc files(Thomas)
162188Even more documention(Thomas)
189+ Nextstep support(Jacek)
190+ Aix support(David)
191+ pginterface manual page(Bruce)
192+ shared libraries all have version numbers
193+ merged all OS-specific shared library defines into one file
194+ smarter TCL/TK configuration checking(Billy)
195+ smarter perl configuration(Brook)
163196
164197
165198