Release 8.3.21

Release date: 2012-09-24

This release contains a variety of fixes from 8.3.20. For information about new features in the 8.3 major release, see Section E.147 .

The PostgreSQL community will stop releasing updates for the 8.3.X release series in February 2013. Users are encouraged to update to a newer release branch soon.

E.126.1. Migration to Version 8.3.21

A dump/restore is not required for those running 8.3.X.

However, if you are upgrading from a version earlier than 8.3.17, see Section E.130 .

E.126.2. Changes

  • Improve page-splitting decisions in GiST indexes (Alexander Korotkov, Robert Haas, Tom Lane)

    Multi-column GiST indexes might suffer unexpected bloat due to this error.

  • Fix cascading privilege revoke to stop if privileges are still held (Tom Lane)

    If we revoke a grant option from some role X , but X still holds that option via a grant from someone else, we should not recursively revoke the corresponding privilege from role(s) Y that X had granted it to.

  • Fix handling of SIGFPE when PL/Perl is in use (Andres Freund)

    Perl resets the process's SIGFPE handler to SIG_IGN , which could result in crashes later on. Restore the normal Postgres signal handler after initializing PL/Perl.

  • Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed (Tom Lane)

  • Work around possible misoptimization in PL/Perl (Tom Lane)

    Some Linux distributions contain an incorrect version of pthread.h that results in incorrect compiled code in PL/Perl, leading to crashes if a PL/Perl function calls another one that throws an error.

  • Update time zone data files to tzdata release 2012f for DST law changes in Fiji