Release date: 2008-06-12
This release contains one serious and one minor bug fix over 8.2.8. For information about new features in the 8.2 major release, see Section E.229.
A dump/restore is not required for those running 8.2.X. However, if you are upgrading from a version earlier than 8.2.7, see Section E.222.
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
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
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.
ALTER AGGREGATE ... OWNER
This oversight could lead to problems if the aggregate
was later involved in a
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.