E.241. Release 8.0.17
Release date: 2008-06-12
This release contains one serious bug fix over 8.0.16. For information about new features in the 8.0 major release, see Section E.258 .
E.241.1. Migration to Version 8.0.17
A dump/restore is not required for those running 8.0.X. However, if you are upgrading from a version earlier than 8.0.6, see Section E.252 .
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)::integerdue 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 DISTINCTview 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.