Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

E.28. Release 7.4.3

Release date: 2004-06-14

This release contains a variety of fixes from 7.4.2.

E.28.1. Migration to version 7.4.3

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

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


 
 
  Published courtesy of The PostgreSQL Global Development Group Design by Interspire