Release Date: 2004-08-16
This release contains a variety of fixes from 7.4.3. For information about new features in the 7.4 major release, see Section E.153.
A dump/restore is not required for those running 7.4.X.
Prevent possible loss of committed transactions during crash
Due to insufficient interlocking between transaction commit and checkpointing, it was possible for transactions committed just before the most recent checkpoint to be lost, in whole or in part, following a database crash and restart. This is a serious bug that has existed since PostgreSQL 7.1.
Check HAVING restriction before evaluating result list of an aggregate plan
Avoid crash when session's current user ID is deleted
Fix hashed crosstab for zero-rows case (Joe)
Force cache update after renaming a column in a foreign key
Pretty-print UNION queries correctly
Make psql handle \r\n newlines properly in COPY IN
pg_dump handled ACLs with grant options incorrectly
Fix thread support for OS X and Solaris
Updated JDBC driver (build 215) with various fixes
Translation updates (various contributors)