选择 打开 改范围 完整检索页

pgsql.cc 提供对 postgresql.org 官网内容的中文翻译,由 Pigsty 团队维护。

不受支持的版本: 9.3 / 9.2 / 9.1 / 9.0
历史版本PostgreSQL 9.2 已于 2017 年 11 月结束社区维护,本页译文保留供仍在使用旧版本的读者参考。新系统请看当前版本手册首页

E.160. Release 8.1.9 #

Release date: 2007-04-23

This release contains a variety of fixes from 8.1.8, including a security fix. For information about new features in the 8.1 major release, see 第 E.169 节.

E.160.1. Migration to Version 8.1.9

A dump/restore is not required for those running 8.1.X. However, if you are upgrading from a version earlier than 8.1.2, see 第 E.167 节.

E.160.2. Changes

  • Support explicit placement of the temporary-table schema within search_path, and disable searching it for functions and operators (Tom)

    This is needed to allow a security-definer function to set a truly secure value of search_path. Without it, an unprivileged SQL user can use temporary objects to execute code with the privileges of the security-definer function (CVE-2007-2138). See CREATE FUNCTION for more information.

  • /contrib/tsearch2 crash fixes (Teodor)

  • Require COMMIT PREPARED to be executed in the same database as the transaction was prepared in (Heikki)

  • Fix potential-data-corruption bug in how VACUUM FULL handles UPDATE chains (Tom, Pavan Deolasee)

  • Planner fixes, including improving outer join and bitmap scan selection logic (Tom)

  • Fix PANIC during enlargement of a hash index (bug introduced in 8.1.6) (Tom)

  • Fix POSIX-style timezone specs to follow new USA DST rules (Tom)

提交更正

译文有误、术语不当或页面显示问题,请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题,请在当前版本的对应页面向上游反馈;上游不再修订已结束维护的版本。