PostgreSQL 6.5

• Release notes
• Released: 1999-06-09 (announcement)
• Final minor version: 6.5.3
• EOL: 1999-10
• Documentation: PostgreSQL 6.5

Major features

• MVCC (initial commit 3f7fbf85)
• temporary tables
• support for CASE, INTERSECT and EXCEPT

Data type changes

Added:

• NUMERIC (commit 0e9d75c6)

SQL changes

Added:

• LIMIT / OFFSET support (commit be948af2)
• SET TRANSACTION (commit 3498d878)

Modified:

• LOCK
  • LOCK TABLE IN ... MODE syntax added (commit 3498d878)

System catalogue changes

Tables

• pg_parg removed (commit 763a7ab6)

Core utilities

Added:

• createlang (commit 3de11d65)
• droplang (commit 3de11d65)

Modified:

• pg_dump
  • use single serializable transaction, meaning database can stay online while a dump is made (commit df9e539e)
  • dump ACLs by default (commit 615e77ed)
  • option -x added to suppress dumping ACLs (commit 615e77ed)
  • option -c added to drop objects before creation (commit 289a826d)
  • dump output format improved (commit 84107b41)

Contrib modules

Added:

• vacuumlo (commit 94bb87f9)