September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

E.174. 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.177.

E.174.1. Migration to Version 7.4.3

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

E.174.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 and LISTEN/NOTIFY

  • Numerous translation updates (various contributors)