1- PostgreSQL 6.4Sat Oct24 00:41:35 EDT 1998
1+ PostgreSQL 6.4Mon Oct26 11:40:42 EST 1998
22=========================================================
33
44A dump/restore is required for those wishing to migrate data from
@@ -10,7 +10,8 @@ Bug Fixes
1010Fix for a tiny memory leak in PQsetdb/PQfinish(Bryan)
1111Remove char2-16 data types, use char/varchar(Darren)
1212Pqfn not handles a NOTICE message(Anders)
13- Short-term locks now retry locking at random times(David)
13+ Reduced busywaiting overhead for spinlocks with many backends (dg)
14+ Stuck spinlock detection (dg)
1415Fix up "ISO-style" timespan decoding and encoding(Thomas)
1516Fix problem with table drop after rollback of transaction(Vadim)
1617Change error message and remove non-functional update message(Vadim)
@@ -19,10 +20,11 @@ Fix for SELECT 1 UNION SELECT NULL
1920Fix for buffer leaks in large object calls(Pascal)
2021Change owner from oid to int4 type(Bruce)
2122Fix a bug in the oracle compatibility functions btrim() ltrim() and rtrim()
22- Fix for usernames longer than eight characters(Tom)
2323Fix for shared invalidation cache overflow(Massimo)
2424Prevent file descriptor leaks in failed COPY's(Bruce)
25- Fix problem with username/passwords over 8 characters(Tom)
25+ Fix memory leak in libpgtcl's pg_select(Constantin)
26+ Fix problems with username/passwords over 8 characters(Tom)
27+ Fix problems with handling of asynchronous NOTIFY in backend(Tom)
2628
2729Enhancements
2830------------
@@ -36,6 +38,9 @@ Select version(); now returns PostgreSQL version(Jeroen)
3638Libpq now allows asynchronous clients(Tom)
3739Allow cancel from client of backend query(Tom)
3840Psql now cancels query with Control-C(Tom)
41+ Libpq users need not issue dummy queries to get NOTIFY messages(Tom)
42+ NOTIFY now sends sender's PID, so you can tell whether it was your own(Tom)
43+ PGresult struct now includes associated error message, if any(Tom)
3944Define "tz_hour" and "tz_minute" arguments to date_part()(Thomas)
4045Add routines to convert between varchar and bpchar(Thomas)
4146Add routines to allow sizing of varchar and bpchar into target columns(Thomas)
@@ -65,8 +70,9 @@ Show backend status on ps command line(only works on some platforms)(Bruce)
6570Pg_hba.conf now has a sameuser option in the database field
6671Make lo_unlink take oid param, not int4
6772New DISABLE_COMPLEX_MACRO for compilers that can't handle our macros(Bruce)
68- Libpgtcl nowgets async notifies from libpq (Tom)
73+ Libpgtcl nowhandles NOTIFY as a Tcl event, need not send dummy queries (Tom)
6974libpgtcl cleanups(Tom)
75+ Add -error option to libpgtcl's pg_result command(Tom)
7076New locale patch, see docs/README/locale(Oleg)
7177Fix for pg_dump so CONSTRAINT and CHECK syntax is correct(ccb)
7278New contrib/lo code for large object orphan removal(Peter)
@@ -80,17 +86,16 @@ New 8-byte integer type, checked by configure for OS support(Thomas)
8086Better support for quited table/column names(Thomas)
8187Surround table and column names with double-quotes(Thomas) in generated
8288sql code to preserve case (SQL92 syntax)(Thomas)
83- New libpqrequestCancel(Tom)
8489PQreset() now works with passwords(Tom)
8590Handle case of GROUP BY target list column number out of range(David)
8691Allow UNION in subselects
8792Add auto-size to screen to \d? commands(Bruce)
8893Use UNION to show all \d? results in one query(Bruce)
8994Add \d? field search feature(Bruce)
9095Pg_dump issues fewer \connect requests(Tom)
91- Document pg_dump -z flag in manual page(Tom)
96+ Make pg_dump -z flag work better, document it in manual page(Tom)
9297Add HAVING clause with full support for subselects and unions(Stephan)
93- Full text indexing routines in contrib/fulltextindex(Marteen )
98+ Full text indexing routines in contrib/fulltextindex(Maarten )
9499Transaction ids now stored in shared memory(Vadim)
95100New PGCLIENTENCODING when issuing COPY command(Tatsuo)
96101Support for SQL92 syntax "SET NAMES"(Tatsuo)
@@ -158,7 +163,7 @@ Allow up to 8 key indexes(Bruce)
158163Remove ARCHIVE keyword, that is no longer used(Thomas)
159164pg_dump -n flag to supress quotes around indentifiers
160165disable system columns for views(Jan)
161- net INET and CIDR types for network addresses(TomH, Paul)
166+ new INET and CIDR types for network addresses(TomH, Paul)
162167no more double quotes in psql output
163168pg_dump now dumps views(Terry)
164169new SET QUERY_LIMIT(Tatsuo,Jan)
@@ -180,7 +185,7 @@ New FAQ_CVS
180185Update backend flowchart in tools/backend(Bruce)
181186Change atttypmod from int16 to int32(Bruce, Tom)
182187Getrusage() fix for platforms that do not have it(Tom)
183- Add PGUSER to libpq man page
188+ AddPQconnectdb, PGUSER, PGPASSWORD to libpq man page
184189NS32K platform fixes(Phil Nelson, John Buller)
185190Sco 7/UnixWare 2.x fixes(Billy,others)
186191Sparc/Solaris 2.5 fixes(Ryan)
@@ -193,6 +198,7 @@ shared libraries all have version numbers
193198merged all OS-specific shared library defines into one file
194199smarter TCL/TK configuration checking(Billy)
195200smarter perl configuration(Brook)
201+ configure uses supplied install-sh if no install script found(Tom)
196202
197203
198204