PostgreSQL 9.1

Major features

SQL changes

General:

Added:

Modified:

Backend changes

Process management

postmaster

Hooks

Following hooks added:

Data type changes

Added:

Modified:

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System function changes

Added:

Modified:

Configuration changes

Added:

Modified:

Indexing changes

GIN

  • recognition of duplicate search entries improved (commit 56a57473)
  • support for indexing NULL anrd empty values added (commit 73912e7f)
  • index scan cost estimation improved (commit 48c7d9f6)

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)
  • following functions added (commit 1c51c7d5):
    • plpy.quote_ident
    • plpy.quote_literal
    • plpy.quote_nullable

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:

libpq changes

  • client_encoding connection parameter added (commit 02e14562)
  • requirepeer connection parameter added (initial commit 040aee29)
  • function PQlibVersion() added (commit de9a4c27)

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)

Server utilities

Modified:

Core utilities

Added:

Modified:

Contrib modules

Added:

Modified:

Testing

Pre-release test versions

Initial commit marking the start of PostgreSQL 9.1 development is b40466c3 (2010-07-09).