PostgreSQL 8.2

Major features

Data type changes

General

SQL changes

Added:

Modified:

System catalogue changes

Tables

Added:

Modified:

Views

Added:

Modified:

System functions

Added:

Configuration changes

Added:

Modified:

Removed:

Indexing changes

  • rtree index method removed in favour of GiST (commit 2a8d3d83)

Replication changes

Information schema changes

Server utilities

  • initdb
    • detects the operating system locale and set the appropriate default DateStyle value (commit 625d4b38)

Core utilities

Modified:

  • pg_dump
    • option -t/--tables now pattern-matches in the same way as psql's \d command (commit 24e97528)
  • pg_restore
    • option --no-data-for-failed-tables added (commit c61607bd)
    • option -1/--single-transaction added (commit 3957cf6e)

Procedural languages

PL/pgSQL

Following hooks added:

Contrib modules

General:

  • uninstall scripts added for all contrib modules with install scripts (commit fe83b3eb)

Added:

Modified:

Removed: