This page in other versions: 9.1 / 9.2 / 9.3 / 9.4 / current (9.5)  |  Development versions: devel  |  Unsupported versions: 8.2 / 8.3 / 8.4 / 9.0

E.157. 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.158.

E.157.1. Migration to Version 8.2.1

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

E.157.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.

Add Comment

Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.

Proceed to the comment form.

Privacy Policy | About PostgreSQL
Copyright © 1996-2016 The PostgreSQL Global Development Group