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)

Indexing changes

  • indexes automatically used for MIN() and MAX() (commit addc42c3)

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:

  • createuser
    • following options added (commit 8ae0d476):
      • -s/--superuser
      • -S/--no-superuser
      • -r/--createrole
      • -R/--no-createrole
      • -l/--login
      • -L/--no-login
      • -i/--inherit
      • -I/--no-inherit
      • -c/--connection-limit
    • following options removed (commit 8ae0d476):
      • -a/--add-user
      • -A/--no-adduser
  • pg_restore
    • option -n/--schema added (commit ebc86498)

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: