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.

3 files changed, 9 insertions, 49 deletions

diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index e7bb435a4e8..d17b6d38f44 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2008/04/05 16:40:08 adam Exp $
+# $NetBSD: Makefile.common,v 1.11 2008/06/20 07:46:49 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -36,7 +36,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql82/patches
 #
 # Note: Do not forget jdbc-postgresql82 when updating version
 #
-DIST_VERS?=		8.2.7
+DIST_VERS?=		8.2.9
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index 9df3bf3e9be..a850b861e58 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,10 +1,10 @@
-$NetBSD: distinfo,v 1.11 2008/04/05 16:40:08 adam Exp $
+$NetBSD: distinfo,v 1.12 2008/06/20 07:46:49 adam Exp $
 
-SHA1 (postgresql-8.2.7.tar.bz2) = 0be0dbaa488810ebcba77ac7246180c5b2a9b669
-RMD160 (postgresql-8.2.7.tar.bz2) = 96700e91c3b9e733c686b0fe377c7ba661710942
-Size (postgresql-8.2.7.tar.bz2) = 12576126 bytes
+SHA1 (postgresql-8.2.9.tar.bz2) = aeaf0487d031c56518af002f76f779c23baf6391
+RMD160 (postgresql-8.2.9.tar.bz2) = 00fe295d928e77a2dff136795ba846ae3ac08569
+Size (postgresql-8.2.9.tar.bz2) = 12558265 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
-SHA1 (patch-ab) = 0cd699b7f9ea3e90e2cbf1a8e516dc224ee3b5f7
+SHA1 (patch-ab) = 138221d6b3b2fe33d68d8d4aacf23b6913f6c809
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9
 SHA1 (patch-ad) = 84ce70fa661b44f267a502ea73fe01b84776c91c
 SHA1 (patch-ae) = 8b3e47320dfe05d94b769c9b079fd7ca6d26f5d6
diff --git a/databases/postgresql82/patches/patch-ab b/databases/postgresql82/patches/patch-ab
index 362b64e54a9..c5ceb9b3929 100644
--- a/databases/postgresql82/patches/patch-ab
+++ b/databases/postgresql82/patches/patch-ab
@@ -1,6 +1,6 @@
-$NetBSD: patch-ab,v 1.3 2008/04/05 16:40:08 adam Exp $
+$NetBSD: patch-ab,v 1.4 2008/06/20 07:46:49 adam Exp $
 
---- configure.orig	2008-03-14 04:30:53.000000000 +0100
+--- configure.orig	2008-06-09 02:34:31.000000000 +0200
 +++ configure
 @@ -1504,6 +1504,7 @@ case $host_os in
    darwin*) template=darwin ;;
@@ -21,43 +21,3 @@ $NetBSD: patch-ab,v 1.3 2008/04/05 16:40:08 adam Exp $
  echo "$as_me:$LINENO: result: $perl_embed_ldflags" >&5
  echo "${ECHO_T}$perl_embed_ldflags" >&6
  fi
-@@ -22087,16 +22086,12 @@ cat >>conftest.$ac_ext <<_ACEOF
- /* end confdefs.h.  */
- 
- /* Override any gcc2 internal prototype to avoid an error.  */
--#ifdef __cplusplus
--extern "C"
--#endif
--/* We use char because int might match the return type of a gcc2
--   builtin and then its argument prototype would still apply.  */
--char gettext ();
-+#include <libintl.h>
-+
- int
- main ()
- {
--gettext ();
-+gettext ("");
-   ;
-   return 0;
- }
-@@ -22142,16 +22137,12 @@ cat >>conftest.$ac_ext <<_ACEOF
- /* end confdefs.h.  */
- 
- /* Override any gcc2 internal prototype to avoid an error.  */
--#ifdef __cplusplus
--extern "C"
--#endif
--/* We use char because int might match the return type of a gcc2
--   builtin and then its argument prototype would still apply.  */
--char gettext ();
-+#include <libintl.h>
-+
- int
- main ()
- {
--gettext ();
-+gettext ("");
-   ;
-   return 0;
- }