©
This document usesPHP Chinese website manualRelease
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 Section E.52.
A dump/restore is not required for those running 8.2.X.
Support explicit placement of the temporary-table schema withinsearch_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 ofsearch_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). SeeCREATE FUNCTIONfor more information.
Fixshared_preload_librariesfor Windows by forcing reload in each backend (Korry Douglas)
Fixto_char()
so it properly upper/lower cases localized day or month names (Pavel Stehule)
/contrib/tsearch2crash fixes (Teodor)
RequireCOMMIT PREPAREDto be executed in the same database as the transaction was prepared in (Heikki)
Allowpg_dumpto do binary backups larger than two gigabytes on Windows (Magnus)
New traditional (Taiwan) ChineseFAQ(Zhou Daojing)
Prevent the statistics collector from writing to disk too frequently (Tom)
Fix potential-data-corruption bug in howVACUUM FULLhandlesUPDATEchains (Tom, Pavan Deolasee)
Fix bug in domains that use array types (Tom)
Fixpg_dumpso it can dump a serial column's sequence using-twhen 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 toRETURNfrom within anEXCEPTIONblock (Tom)
Fix PANIC during enlargement of a hash index (Tom)
Fix POSIX-style timezone specs to follow new USA DST rules (Tom)