↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

已结束支持的版本: 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2
历史版本。 PostgreSQL 9.2 已结束支持。 2017-11-09. 请参阅 当前版本手册.

E.144. 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 第 E.145 节.

E.144.1. Migration to Version 8.2.1

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

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

报告文档问题

阅读 上游文档. 反馈更正前请先核对 当前版本手册.