E.247. Release 7.4.3

[Note]

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.250, « Release 7.4 ».

E.247.1. Migration to Version 7.4.3

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

E.247.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)