E.222. 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.223 .
E.222.1. Migration to Version 8.2.1
A dump/restore is not required for those running 8.2.
E.222.2. Changes
-
Fix crash with
SELECT
...LIMIT ALL
(alsoLIMIT 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
.