Release date: 2008-06-12
This release contains one serious and one minor bug fix over 8.1.12. For information about new features in the 8.1 major release, see Section E.236.
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.234.
Make pg_get_ruledef()
parenthesize
negative constants (Tom)
Before this fix, a negative constant in a view or rule might be
dumped as, say, -42::integer
, which is
subtly incorrect: it should be (-42)::integer
due to operator precedence rules.
Usually this would make little difference, but it could interact
with another recent patch to cause PostgreSQL to reject what had been a valid
SELECT DISTINCT
view query. Since this
could result in pg_dump output
failing to reload, it is being treated as a high-priority fix. The
only released versions in which dump output is actually incorrect
are 8.3.1 and 8.2.7.
Make ALTER AGGREGATE ... OWNER TO
update pg_shdepend
(Tom)
This oversight could lead to problems if the aggregate was later
involved in a DROP OWNED
or
REASSIGN OWNED
operation.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.