PostgreSQL 9.0

Major features

SQL changes

Added:

Modified:

Backend changes

General

  • relation mapping infrastructure added (commit b9b8831a)

Data directory

Vacuuming

Hooks

Following hooks added:

Internals

  • genbki.sh and Gen_fmgrtab.sh entirely replaced by genbki.pl and Gen_fmgrtab.pl (commit 64737e93)

System catalogue changes

Tables

Added:

Modified:

Removed:

Views

Modified:

System functions

Added:

Configuration changes

Added:

Modified:

Data types

Modified:

libpq changes

Replication changes

Configuration

Added:

Full text search changes

  • prefix support for synonym dictionaries added (commit abd8c94f)
  • filtering dictionary support added (commit a88a4801)
  • underscores in email addresses supported (commit 89b0095e)
  • URL parsing improved to be more standards-compliant (commit 2c265ade)

Procedural language changes

PL/pgSQL

  • installed by default (commit 96c102fe)

PL/Perl

  • support for DO blocks added (commit 42b2907d)
  • various following utility functions added (commit 05672e50)

PL/Python

Server utilities

Modified:

Core utilities

Added:

Contrib modules

Added:

Modified:

Pre-release test versions

Initial commit marking the start of PostgreSQL 9.0 development is 50a90fac (2010-02-17).