E.5.1. Migration to version 8.2.1

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

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