PostgreSQLLa base de données la plus sophistiquée au monde.

E.39. Version 8.2.9


Date de sortie


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.48, « Version 8.2 ».

E.39.1. Migration vers la version 8.2.9

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.

E.39.2. Modifications

  • 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.