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.246.1. Migration to Version 7.2.8

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

E.246.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)