PostgreSQL 8.3

Major features

SQL changes

Added:

Modified:

Backend changes

Hooks

Following hooks added:

SPI

  • following functions added (commit 66888f74):
    • SPI_prepare_cursor()
    • SPI_scroll_cursor_fetch()
    • SPI_scroll_cursor_move()

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System function changes

Added:

Modified:

Data type changes

Added:

Configuration changes

Added:

Modified

Removed:

Logging changes

  • log file output can optionally be generated in CSV format (fd801f4f)

Replication changes

Configuration

Added:

Procedural language changes

PL/pgSQL

  • support for scrollable cursors added (commit f01b1965)
  • RETURN QUERY syntax added (commit b2b9b4d5)

Server utilities

  • initdb
    • the location of the pg_xlog directory can now be specified with option -X/--xlogdir (commit c3578a68)
  • pg_ctl
    • option -c added to allow server crashes to produce core files (commit 226e9fff)
    • option -t added to control timeouts for server startup/shutdown; default: 60 seconds (commit 6e414a17)

Core utilities

Contrib modules

General:

  • Most contrib module documentation moved from README files to the main documentation (commit c3c69ab4).

Added:

Modified: