Version 6.5 (Released June 1999)

I l @ ve RuBoard

Multiversion Concurrency Control (MVCC) ”Removed older table-level locking mechanisms.

Hot backups from pg_dump ”Capability to backup/restore while database is operational.

Numeric data type ”Added a new NUMERIC data type.

Temporary tables ”Temporary tables are guaranteed to have unique names within a database session and are destroyed on session exit.

Ports ”Expand ports list, including WinNT/ix86 and NetBSD/arm32.

New SQL features ”Added CASE , INTERSECT , and EXCEPT statement support. There is a new LIMIT/OFFSET , SET TRANSACTION ISOLATION LEVEL , and SELECT FOR UPDATE , and an improved LOCK TABLE command.

Added vacuumdb utility.

Using EXPLAIN , all indices used.

New pg_dump table output format.

Added string min()/max() functions.

Update to pgaccess 0.96 (Constantin).

Improved substr() function.

Improved multibyte handling (Tatsuo).

New SERIALIZED transaction mode.

Fixed tables over 2GB.

New SET TRANSACTION ISOLATION LEVEL .

New LOCK TABLE IN MODE .

Updated ODBC driver.

New SELECT FOR UPDATE .

New TCL_ARRAYS option (Massimo).

New INTERSECT and EXCEPT (Stefan).

New READ COMMITTED isolation level.

New TEMP tables/indexes.

Allowed multiple rule actions.

New routines to convert between int8 and text/varchar types.

Enabled right-hand queries by default.

Added new Postgres -O option to allow system table structure changes.

Support for arrays of char( ) and varchar() fields.

UNION now supports ORDER BY of columns not in target list.

INET type now respects netmask for comparisons.

Allowed VIEWs on UNIONs .

I l @ ve RuBoard