Release Date: 2004-06-14
This release contains a variety of fixes from 7.4.2. For information about new features in the 7.4 major release, see Section E.173.
A dump/restore is not required for those running 7.4.X.
Fix temporary memory leak when using non-hashed aggregates (Tom)
ECPG fixes, including some for Informix compatibility (Michael)
Fixes for compiling with thread-safety, particularly Solaris (Bruce)
Fix error in COPY IN termination when using the old network protocol (ljb)
Several important fixes in pg_autovacuum, including fixes for large tables, unsigned oids, stability, temp tables, and debug mode (Matthew T. O'Connor)
Fix problem with reading tar-format dumps on NetBSD and BSD/OS (Bruce)
Several JDBC fixes
Fix ALTER SEQUENCE RESTART where last_value equals the restart value (Tom)
Repair failure to recalculate nested sub-selects (Tom)
Fix problems with non-constant expressions in LIMIT/OFFSET
Support FULL JOIN with no join clause, such as X FULL JOIN Y ON TRUE (Tom)
Fix another zero-column table bug (Tom)
Improve handling of non-qualified identifiers in GROUP BY clauses in sub-selects (Tom)
Select-list aliases within the sub-select will now take precedence over names from outer query levels.
Do not generate "NATURAL CROSS JOIN" when decompiling rules (Tom)
Add checks for invalid field length in binary COPY (Tom)
This fixes a difficult-to-exploit security hole.
Avoid locking conflict between ANALYZE and LISTEN/NOTIFY
Numerous translation updates (various contributors)