select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
Historical version. PostgreSQL 9.2 reached end of support in November 2017. See the current manual for supported releases.

E.205. Release 7.4.22

Release date: 2008-09-22

This release contains a variety of fixes from 7.4.21. For information about new features in the 7.4 major release, see Section E.227.

E.205.1. Migration to Version 7.4.22

A dump/restore is not required for those running 7.4.X. However, if you are upgrading from a version earlier than 7.4.11, see Section E.216.

E.205.2. Changes

  • Fix datetime input functions to correctly detect integer overflow when running on a 64-bit platform (Tom)

  • Improve performance of writing very long log messages to syslog (Tom)

  • Fix bug in backwards scanning of a cursor on a SELECT DISTINCT ON query (Tom)

  • Fix planner to estimate that GROUP BY expressions yielding boolean results always result in two groups, regardless of the expressions' contents (Tom)

    This is very substantially more accurate than the regular GROUP BY estimate for certain boolean tests like col IS NULL.

  • Improve pg_dump and pg_restore's error reporting after failure to send a SQL command (Tom)

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.