PostgreSQL 7.4

Major features

SQL changes

Added:

Modified:

Backend changes

Cursors

  • support for holdable cursors added (commit 54f7338f)

System catalogue

Tables

Modified:

Views

Modified:

System functions

Added:

Modified:

Data types

Configuration changes

Added:

libpq changes

Connection parameters

  • tty option deprecated (commit cb7fb3ca)

psql changes

  • prompt option %x added to show transaction status (initial commit f9ebf369 as %T, later changed to %x in commit 9951474c)

Core utilities

Modified:

Contrib modules

Added:

Modified:

  • dblink
    • named persistent connections added (commit 8f337e86)
  • lo
    • casts between the lo and oid data types added (commit 9ab7ab51)
  • tablefunc
    • hash-based crosstab function added (commit 64d0b8b0)
    • serial column added to order connectby() siblings (commit a265b7f7)