E.47.1. Migration to version 7.4.4

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

E.47.2. Changes

• 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

• ECPG fixes

• Translation updates (various contributors)