PostgreSQL 2011-12-05 Update Release

The PostgreSQL Global Development Group today released updates for all
active branches of the PostgreSQL object-relational database system,
including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23. Users of
any of the several affected features in this release, including binary
replication, should update their PostgreSQL installations as soon as
possible.

This is also the last update for PostgreSQL 8.2, which is now
End-Of-Life (EOL). Users of version 8.2 should plan to upgrade their
PostgreSQL installations to 8.3 or later within the next couple of
months. For more information, see our Release Support Policy:
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

The features affected by this update include: binary replication and hot
standby, GIN indexes, the citext Extension, pg_upgrade, window function
aggregate sorting, self-referential foreign keys, PL/perl, and general
Extension handling. Users of these features should apply the updates
right away.

This release contains 52 fixes to version 9.1, and a smaller number of
fixes to older versions, including:

- Fix bugs in information_schema.referential_constraints view**
- Correct collations for citext columns and indexes**
- Prevent possible crash when joining to a scalar function
- Prevent transitory data corruption of GIN indexes after a crash
- Prevent data corruption on TOAST columns when copying data
- Fix failures during hot standby startup
- Correct another "variable not found in subplan target list" bug
- Fix bug with sorting on aggregate expressions in windowing functions
- Multiple bug fixes for pg_upgrade
- Change Foreign Key creation order to better support
self-referential keys**
- Multiple bug fixes to CREATE EXTENSION
- Ensure that function return type and data returned from PL/perl agree
- Ensure that PL/perl strings are always UTF-8
- Assorted bug fixes for various Extensions
- Updates to the time zone database, particularly to CST6

Changes marked with ** above require additional, post-update steps in
order to fix all described issues. See the release notes for each
version for a full list of changes with details of the fixes and steps:
http://www.postgresql.org/docs/current/static/release.html

As with other minor releases, users are not required to dump and reload
their database or use pg_upgrade in order to apply this update release;
you may simply shut down PostgreSQL and update its binaries. Perform
post-update steps after the database is restarted.

Download new versions now:
* Main download page: http://www.postgresql.org/download
* Source code: http://www.postgresql.org/ftp/source/
* Binary packages: http://www.postgresql.org/ftp/binary/
* One-click installer, including Windows packages:
http://www.enterprisedb.com/products/pgdownload.do