Release 8.3.3
| PostgreSQL 9.6.8 Documentation | |||
|---|---|---|---|
| Prev | Up | Appendix E. Release Notes | Next |
Release date: 2008-06-12
This release contains one serious and one minor bug fix over 8.3.2. For information about new features in the 8.3 major release, see Section E.184 .
E.181.1. Migration to Version 8.3.3
A dump/restore is not required for those running 8.3.X. However, if you are upgrading from a version earlier than 8.3.1, see Section E.183 .
E.181.2. Changes
-
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.