PostgreSQLLa base de données la plus sophistiquée au monde.

E.136. Release 8.0.10

[Note]

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.146, « Release 8.0 ».

E.136.1. Migration to Version 8.0.10

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.140, « Release 8.0.6 ».

E.136.2. Changes

  • 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_number() and 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.