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

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

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

E.83. Release 8.4.14 #

Release date: 2012-09-24

This release contains a variety of fixes from 8.4.13. For information about new features in the 8.4 major release, see 第 E.97 节.

E.83.1. Migration to Version 8.4.14

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

However, if you are upgrading from a version earlier than 8.4.10, see 第 E.87 节.

E.83.2. Changes

  • Fix planner's assignment of executor parameters, and fix executor's rescan logic for CTE plan nodes (Tom Lane)

    These errors could result in wrong answers from queries that scan the same WITH subquery multiple times.

  • Improve page-splitting decisions in GiST indexes (Alexander Korotkov, Robert Haas, Tom Lane)

    Multi-column GiST indexes might suffer unexpected bloat due to this error.

  • Fix cascading privilege revoke to stop if privileges are still held (Tom Lane)

    If we revoke a grant option from some role X, but X still holds that option via a grant from someone else, we should not recursively revoke the corresponding privilege from role(s) Y that X had granted it to.

  • Fix handling of SIGFPE when PL/Perl is in use (Andres Freund)

    Perl resets the process's SIGFPE handler to SIG_IGN, which could result in crashes later on. Restore the normal Postgres signal handler after initializing PL/Perl.

  • Prevent PL/Perl from crashing if a recursive PL/Perl function is redefined while being executed (Tom Lane)

  • Work around possible misoptimization in PL/Perl (Tom Lane)

    Some Linux distributions contain an incorrect version of pthread.h that results in incorrect compiled code in PL/Perl, leading to crashes if a PL/Perl function calls another one that throws an error.

  • Update time zone data files to tzdata release 2012f for DST law changes in Fiji

提交更正

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