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.

2 files changed, 13 insertions, 3 deletions

diff --git a/databases/postgresql82-client/Makefile b/databases/postgresql82-client/Makefile
index a295785c5fe..056fe23a885 100644
--- a/databases/postgresql82-client/Makefile
+++ b/databases/postgresql82-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.4 2008/04/05 16:40:08 adam Exp $
+# $NetBSD: Makefile,v 1.5 2008/06/20 07:46:49 adam Exp $
 
 PKGNAME=	postgresql82-client-${BASE_VERS}
 COMMENT=	PostgreSQL database client programs
@@ -36,6 +36,7 @@ CONFIGURE_ARGS+=	--enable-thread-safety
 
 INSTALL_DIRS=	src/include
 INSTALL_DIRS+=	src/interfaces
+INSTALL_DIRS+=	src/port
 INSTALL_DIRS+=	src/bin
 INSTALL_DIRS+=	doc
 
diff --git a/databases/postgresql82-client/PLIST b/databases/postgresql82-client/PLIST
index 0386d4ac9a2..6af80c71781 100644
--- a/databases/postgresql82-client/PLIST
+++ b/databases/postgresql82-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2008/04/05 16:40:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.9 2008/06/20 07:46:49 adam Exp $
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/af/LC_MESSAGES/libpq.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/initdb.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/libpq.mo
@@ -549,6 +549,7 @@ ${PG_SUBPREFIX}include/sql3types.h
 ${PG_SUBPREFIX}include/sqlca.h
 ${PG_SUBPREFIX}lib/libecpg.la
 ${PG_SUBPREFIX}lib/libecpg_compat.la
+${PG_SUBPREFIX}lib/libpgport.a
 ${PG_SUBPREFIX}lib/libpgtypes.la
 ${PG_SUBPREFIX}lib/libpq.la
 ${PG_SUBPREFIX}man/man1/clusterdb.1
@@ -1194,6 +1195,8 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-19.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-20.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1210,6 +1213,8 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-14.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-15.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-16.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
@@ -1222,6 +1227,8 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-11.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-12.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1239,6 +1246,8 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-8.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-9.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/role-attributes.html
@@ -1504,7 +1513,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/wal-intro.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/wal-reliability.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/wal.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/warm-standby.html
-${PG_SUBPREFIX}share/doc/postgresql/html/x71208.html
+${PG_SUBPREFIX}share/doc/postgresql/html/x71214.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xaggr.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xfunc-c.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xfunc-internal.html