September 26, 2024: PostgreSQL 17 Released!
Unsupported versions: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2
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.94. Release 8.2.1

Release Date: 2007-01-08

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

E.94.1. Migration to Version 8.2.1

A dump/restore is not required for those running 8.2.

E.94.2. Changes

  • Fix crash with SELECT ... LIMIT ALL (also LIMIT NULL) (Tom)

  • Several /contrib/tsearch2 fixes (Teodor)

  • On Windows, make log messages coming from the operating system use ASCII encoding (Hiroshi Saito)

    This fixes a conversion problem when there is a mismatch between the encoding of the operating system and database server.

  • Fix Windows linking of pg_dump using win32.mak (Hiroshi Saito)

  • Fix planner mistakes for outer join queries (Tom)

  • Fix several problems in queries involving sub-SELECTs (Tom)

  • Fix potential crash in SPI during subtransaction abort (Tom)

    This affects all PL functions since they all use SPI.

  • Improve build speed of PDF documentation (Peter)

  • Re-add JST (Japan) timezone abbreviation (Tom)

  • Improve optimization decisions related to index scans (Tom)

  • Have psql print multi-byte combining characters as before, rather than output as \u (Tom)

  • Improve index usage of regular expressions that use parentheses (Tom)

    This improves psql \d performance also.

  • Make pg_dumpall assume that databases have public CONNECT privilege, when dumping from a pre-8.2 server (Tom)

    This preserves the previous behavior that anyone can connect to a database if allowed by pg_hba.conf.