PostgreSQL 8.3

Major features

  • native full text search functionality (commit 140d4ebc)
  • HOT updates (commit 282d2a03)
  • ENUM data type
  • uuid data type
  • XML data type support (initial commit 8c1de5fb)

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:

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)

Procedural language changes

PL/pgSQL

  • support for scrollable cursors added (commit f01b1965)

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:

  • hstore
    • GIN and GiST support added, along with other improvements (commit 754148d8)
  • pg_buffercache
    • usagecount column added to show usage count statistics (commit b0194ab1)
  • pgstattuple
    • following functions moved to new contrib module pageinspect (commit 64058429):
      • bt_metap()
      • bt_page_items()
      • bt_page_stats()
    • function execution restricted to superusers (commit 38c75ecf)
  • tsearch2
    • converted to provide backwards compatibility following the integration of full text search into core PostgreSQL (commit 90e3f2ac)
  • xml2
    • marked as deprecated (commit 4e3cb9ca)