pgsql.cc 提供对 postgresql.org 官网内容的中文翻译,由 Pigsty 团队维护。
Release date: 2007-04-23
This release contains a variety of fixes from 8.2.3, including a security fix. For information about new features in the 8.2 major release, see 第 E.145 节.
A dump/restore is not required for those running 8.2.X.
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.
Fix shared_preload_libraries for Windows by forcing reload in each backend (Korry Douglas)
Fix to_char() so it properly upper/lower cases localized day or month names (Pavel Stehule)
/contrib/tsearch2 crash fixes (Teodor)
Require COMMIT PREPARED to be executed in the same database as the transaction was prepared in (Heikki)
Allow pg_dump to do binary backups larger than two gigabytes on Windows (Magnus)
New traditional (Taiwan) Chinese FAQ (Zhou Daojing)
Prevent the statistics collector from writing to disk too frequently (Tom)
Fix potential-data-corruption bug in how VACUUM FULL handles UPDATE chains (Tom, Pavan Deolasee)
Fix bug in domains that use array types (Tom)
Fix pg_dump so it can dump a serial column's sequence using -t when not also dumping the owning table (Tom)
Planner fixes, including improving outer join and bitmap scan selection logic (Tom)
Fix possible wrong answers or crash when a PL/pgSQL function tries to RETURN from within an EXCEPTION block (Tom)
Fix PANIC during enlargement of a hash index (Tom)
Fix POSIX-style timezone specs to follow new USA DST rules (Tom)
译文有误、术语不当或页面显示问题,请到译文仓库 pgsty/pgdoc 报告译文问题。 英文原文本身的问题,请在当前版本的对应页面向上游反馈;上游不再修订已结束维护的版本。