## E.226. 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.227.

### E.226.1. Migration to Version 8.2.1

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

### E.226.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`.