PostgreSQL 6.5

Major features

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

Data type changes

Added:

SQL changes

Added:

Modified:

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

System catalogue changes

Tables

Core utilities

Added:

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: