CVS commit: pkgsrc/databases

[Adam Ciarcinski <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jun 20 07:46:49 UTC 2008

Modified Files:
        pkgsrc/databases/postgresql82: Makefile.common distinfo
        pkgsrc/databases/postgresql82-client: Makefile PLIST
        pkgsrc/databases/postgresql82-server: PLIST
        pkgsrc/databases/postgresql82/patches: patch-ab

Log Message:
Changes 8.2.9:
* 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.


To generate a diff of this commit:
cvs rdiff -r1.10 -r1.11 pkgsrc/databases/postgresql82/Makefile.common
cvs rdiff -r1.11 -r1.12 pkgsrc/databases/postgresql82/distinfo
cvs rdiff -r1.4 -r1.5 pkgsrc/databases/postgresql82-client/Makefile
cvs rdiff -r1.8 -r1.9 pkgsrc/databases/postgresql82-client/PLIST
cvs rdiff -r1.5 -r1.6 pkgsrc/databases/postgresql82-server/PLIST
cvs rdiff -r1.3 -r1.4 pkgsrc/databases/postgresql82/patches/patch-ab

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.