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

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.140. Release 8.2.5 #

Release date: 2007-09-17

This release contains a variety of fixes from 8.2.4. For information about new features in the 8.2 major release, see 第 E.145 节.

E.140.1. Migration to Version 8.2.5

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

E.140.2. Changes

  • Prevent index corruption when a transaction inserts rows and then aborts close to the end of a concurrent VACUUM on the same table (Tom)

  • Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over domains (Tom)

  • Make CREATE DOMAIN ... DEFAULT NULL work properly (Tom)

  • Fix some planner problems with outer joins, notably poor size estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL (Tom)

  • Allow the interval data type to accept input consisting only of milliseconds or microseconds (Neil)

  • Allow timezone name to appear before the year in timestamp input (Tom)

  • Fixes for GIN indexes used by /contrib/tsearch2 (Teodor)

  • Speed up rtree index insertion (Teodor)

  • Fix excessive logging of SSL error messages (Tom)

  • Fix logging so that log messages are never interleaved when using the syslogger process (Andrew)

  • Fix crash when log_min_error_statement logging runs out of memory (Tom)

  • Fix incorrect handling of some foreign-key corner cases (Tom)

  • Fix stddev_pop(numeric) and var_pop(numeric) (Tom)

  • Prevent REINDEX and CLUSTER from failing due to attempting to process temporary tables of other sessions (Alvaro)

  • Update the time zone database rules, particularly New Zealand's upcoming changes (Tom)

  • Windows socket and semaphore improvements (Magnus)

  • Make pg_ctl -w work properly in Windows service mode (Dave Page)

  • Fix memory allocation bug when using MIT Kerberos on Windows (Magnus)

  • Suppress timezone name (%Z) in log timestamps on Windows because of possible encoding mismatches (Tom)

  • Require non-superusers who use /contrib/dblink to use only password authentication, as a security measure (Joe)

  • Restrict /contrib/pgstattuple functions to superusers, for security reasons (Tom)

  • Do not let /contrib/intarray try to make its GIN opclass the default (this caused problems at dump/restore) (Tom)

报告文档问题

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