PostgreSQL 7.2

Major features

Backend changes

Locking changes

  • lightweight lockmanager added (commit 499abb0c)

SPI changes

  • following functions added (commit d27f363e):
    • SPI_cursor_open()
    • SPI_cursor_find()
    • SPI_cursor_fetch()
    • SPI_cursor_fetch()
    • SPI_freeplan()
    • SPI_freetuptable()
  • function SPI_copytupledesc() added (commit f59f3c88)

SQL changes

Added:

Modified:

DDL changes

  • Table OIDs no longer mandatory

System catalogue changes

Tables

Modified:

Removed:

Note: tables removed in commit 1e7b79ce were unused.

Views

Added (all commit 8d80b0d9):

System functions

Added:

Modified:

Configuration changes

Added:

Procedural language changes

PL/pgSQL

  • support for CURSOR and REFCURSOR syntax (commit d27f363e)

PL/Python

Server utilities

Core utilities

Modified:

Contrib modules

Added:

Modified:

  • pgcrypto - following functions added (commit 2518e273):
    • crypt()
    • hmac()
    • decrypt()
    • encrypt()
    • gen_salt()