PostgreSQL 8.1

Major features

  • re-work of user/roles management
  • two-phase commit (commit d0a89683)
  • index bitmap scan
  • shared row locking
  • integrated autovacuum (commit 29094193)
  • support for IN/OUT/INOUT parameters in functions

SQL changes

Added:

Modified:

Backend changes

General

  • Default database postgres added (commit 6f7fc0ba)

Locking

  • Sharable row-level locks added (commit bedb78d3)

System catalogue changes

Tables

Added:

Modified:

Removed:

Views

Added:

Modified:

System function changes

Added:

Modified:

Configuration changes

Added:

Server utilities

Modified:

  • initdb
    • creates a database called postgres by default (commit 6f7fc0ba)
  • pg_config
    • if no option supplied, all available parameters are displayed (commit cbd015d7)
    • various compiler-related options added (commit cbd015d7)

Core utilities

Modified:

Contrib modules

Added:

Modified:

  • lo
    • lo data type converted to a Domain over the oid data type (5b0c9d36)
  • pgcrypto - implementation of OpenPGP symmetric-key and public-key encryption, including following new functions (commit 73e24318):
    • pgp_pub_encrypt()
    • pgp_pub_decrypt()
    • pgp_pub_encrypt_bytea()
    • pgp_pub_decrypt_bytea()
    • pgp_sym_encrypt()
    • pgp_sym_decrypt()
    • pgp_sym_encrypt_bytea()
    • pgp_sym_decrypt_bytea()

Removed: