Release Date: 2007-01-08
This release contains a variety of fixes from 8.0.9. For information about new features in the 8.0 major release, see Section E.224.
A dump/restore is not required for those running 8.0.X. However, if you are upgrading from a version earlier than 8.0.6, see Section E.218.
Improve handling of
getaddrinfo() on AIX (Tom)
This fixes a problem with starting the statistics collector, among other things.
Fix "failed to re-find parent key" errors in VACUUM (Tom)
Fix race condition for truncation of a large relation across a gigabyte boundary by VACUUM (Tom)
Fix bugs affecting multi-gigabyte hash indexes (Tom)
Fix possible deadlock in Windows signal handling (Teodor)
Fix error when constructing an ARRAY made up of multiple empty elements (Tom)
Fix ecpg memory leak during connection (Michael)
to_char(numeric) are now
STABLE, not IMMUTABLE, for new initdb installs (Tom)
This is because lc_numeric can potentially change the output of these functions.
Improve index usage of regular expressions that use parentheses (Tom)
This improves psql \d performance also.
Update timezone database
This affects Australian and Canadian daylight-savings rules in particular.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.