Documentation PostgreSQL 8.2.23 > Annexes > Notes de version > Version 8.2.9 | |
Version 8.2.10 | Version 8.2.8 |
2008-06-12
This release contains one serious and one minor bug fix over 8.2.8. Pour plus d'informations sur les nouvelles fonctionnalités de la version majeure 8.2, voir Section E.24, « Version 8.2 ».
Une sauvegarde/restauration n'est pas nécessaire aux utilisateurs de la version 8.2.X. However, if you are upgrading from a version earlier than 8.2.7, see the release notes for 8.2.7.
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.