PostgreSQL 7.1

Major features

  • WAL
  • TOAST tables
  • outer join syntax
  • SQL syntax updated to allow more complex queries

SQL changes

Added:

Modified:

  • ALTER USER
    • IN GROUP option (which was previously parsed but had no effect) removed (commit 4ceb2d0c)
    • SYSID option removed (commit 4ceb2d0c)
  • CREATE DATABASE
    • WITH TEMPLATE clause added to enable selection of a template database as an alternative to the default "template0" (commit 2cf48ca0)

Backend changes

Process management

System catalogue changes

Tables

Added:

Removed:

System function changes

Added:

Configuration changes

General:

Added:

libpq changes

Server utilities

Added:

Core utilities

Added:

Modified:

Contrib modules

Added: