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.229.
A dump/restore is not required for those running 8.2.
Fix crash with
LIMIT ALL (also
LIMIT NULL) (Tom)
/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
Improve index usage of regular expressions that use parentheses (Tom)
This improves psql
\d performance also.
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
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.