PostgreSQL 9.1

Major features

SQL changes

General:

  • Support for INSERT/UPDATE/DELETE in WITH (commit 389af951)

Added:

Modified:

Backend changes

Process management

  • postmaster.pid
    • lines with port number and socket directory added (commit 075354ad)
    • lines with first listen_address and start time added (commit 30aeda43)

postmaster

Hooks

Following hooks added:

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System function changes

Added:

Modified:

Data type changes

Added:

Modified:

Configuration changes

Added:

Modified:

Procedural language changes

General

PL/pgSQL

  • support for COLLATE clause in variable declarations (commit c9473258)
  • FOREACH IN ARRAY looping syntax added (commit 6e02755b)

PL/Perl

  • PostgreSQL arrays converted to PL/Perl arrays in input arguments (commit 87bb2ade)

PL/Python

  • support for explicit subtransactions added (commit 22690719)
  • support for table functions added (commit bc411f25)
  • validator function added (commit 15f55cc3)

Replication changes

General

  • Streaming replication replay control functions added (initial commit 8c6e3adb)
  • Recovery can now be paused after reaching the recovery target (initial commit 8c6e3adb)
  • Named recovery targets (commit c016ce72)

Configuration

Added:

Server utilities

Modified:

libpq changes

  • client_encoding connection parameter added (commit 02e14562)

psql changes

  • \conninfo command to display current connection info added (commit 013ed0bd)
  • \sf command to display definition of a function added (commit b6e06942)
  • \dL command to list available languages added (commit 9c5e2c12)
  • \dn now ignores system schemas by default, \dnS includes them (commit e43fb604)
  • \dO command to list available collations added (commit b313bca0)

Core utilities

Added:

Contrib modules

Added:

Modified:

Testing