| PostgreSQL 8.2.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Appendix E. Release Notes | Fast Forward | Next |
Release date: 2005-05-09
This release contains a variety of fixes from 7.2.7, including one security-related issue.
A dump/restore is not required for those running 7.2.X.
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)