E.281. Release 7.4.3
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.284 .
E.281.1. Migration to Version 7.4.3
A dump/restore is not required for those running 7.4.X.
E.281.2. Changes
-
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
andLISTEN
/NOTIFY
-
Numerous translation updates (various contributors)