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

Documentation PostgreSQL 8.3.5 > Annexes > Notes de version > Version 7.4.21
PrécédentVersion 7.4.22 Version 7.4.20Suivant

E.57. Version 7.4.21

[Note]

Date de sortie

2008-06-12

This release contains one serious bug fix over 7.4.20. Pour plus d'informations sur les nouvelles fonctionnalités de la version majeure 7.4, voir Section E.78, « Sortie 7.4 ».

E.57.1. Migration vers la version 7.4.21

Une sauvegarde/restauration n'est pas nécessaire aux utilisateurs de la version 7.4.X. However, if you are upgrading from a version earlier than 7.4.11, see the release notes for 7.4.11.

E.57.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.