E.217. 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 Section E.226 .
E.217.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 Section E.224 .
E.217.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). SeeCREATE FUNCTIONfor more information. -
/contrib/tsearch2crash fixes (Teodor) -
Require
COMMIT PREPAREDto be executed in the same database as the transaction was prepared in (Heikki) -
Fix potential-data-corruption bug in how
VACUUM FULLhandlesUPDATEchains (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)