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.171.
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.169.
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)
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
Proceed to the comment form.