CVS commit: pkgsrc/databases

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

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Jun 20 06:54:42 UTC 2008

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

Log Message:
Changes 8.3.3:
* 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.2 -r1.3 pkgsrc/databases/postgresql83/Makefile.common \
    pkgsrc/databases/postgresql83/distinfo
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql83-client/Makefile \
    pkgsrc/databases/postgresql83-client/PLIST
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql83-server/PLIST
cvs rdiff -r1.2 -r1.3 pkgsrc/databases/postgresql83/patches/patch-ab

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