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
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.137. Release 8.0.9

Release Date: 2006-10-16

This release contains a variety of fixes from 8.0.8. For information about new features in the 8.0 major release, see Section E.146.

E.137.1. Migration to Version 8.0.9

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.

E.137.2. Changes

  • Fix crash when referencing NEW row values in rule WHERE expressions (Tom)

  • Fix core dump when an untyped literal is taken as ANYARRAY

  • Fix mishandling of AFTER triggers when query contains a SQL function returning multiple rows (Tom)

  • Fix ALTER TABLE ... TYPE to recheck NOT NULL for USING clause (Tom)

  • Fix string_to_array() to handle overlapping matches for the separator string

    For example, string_to_array('123xx456xxx789', 'xx').

  • Fix corner cases in pattern matching for psql's \d commands

  • Fix index-corrupting bugs in /contrib/ltree (Teodor)

  • Numerous robustness fixes in ecpg (Joachim Wieland)

  • Fix backslash escaping in /contrib/dbmirror

  • Fix instability of statistics collection on Win32 (Tom, Andrew)

  • Fixes for AIX and Intel compilers (Tom)