12th September 2019: PostgreSQL 12 Beta 4 Released!
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the supported versions listed above instead.

E.129. Release 7.2.8

Release date: 2005-05-09

This release contains a variety of fixes from 7.2.7, including one security-related issue.

E.129.1. Migration to Version 7.2.8

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

E.129.2. Changes

  • Repair ancient race condition that allowed a transaction to be seen as committed for some purposes (eg SELECT FOR UPDATE) slightly sooner than for other purposes

    This is an extremely serious bug since it could lead to apparent data inconsistencies being briefly visible to applications.

  • Repair race condition between relation extension and VACUUM

    This could theoretically have caused loss of a page's worth of freshly-inserted data, although the scenario seems of very low probability. There are no known cases of it having caused more than an Assert failure.

  • Fix EXTRACT(EPOCH) for TIME WITH TIME ZONE values

  • Additional buffer overrun checks in plpgsql (Neil)

  • Fix pg_dump to dump index names and trigger names containing % correctly (Neil)

  • Prevent to_char(interval) from dumping core for month-related formats

  • Fix contrib/pgcrypto for newer OpenSSL builds (Marko Kreen)