Update to postgresql 7.3.9. This release contains a variety of fixes

from 7.3.8, including several security-related issues. A dump/restore
is not required for those running 7.3.X.

Changes

     * Disallow "LOAD" to non-superusers
       On platforms that will automatically execute initialization
       functions of a shared library (this includes at least Windows and
       ELF-based Unixen), "LOAD" can be used to make the server execute
       arbitrary code. Thanks to NGS Software for reporting this.
     * Check that creator of an aggregate function has the right to
       execute the specified transition functions
       This oversight made it possible to bypass denial of EXECUTE
       permission on a function.
     * Fix security and 64-bit issues in contrib/intagg
     * Add needed STRICT marking to some contrib functions (Kris Jurka)
     * Avoid buffer overrun when plpgsql cursor declaration has too many
       parameters (Neil)
     * Fix planning error for FULL and RIGHT outer joins
       The result of the join was mistakenly supposed to be sorted the
       same as the left input. This could not only deliver mis-sorted
       output to the user, but in case of nested merge joins could give
       outright wrong answers.
     * Fix plperl for quote marks in tuple fields
     * Fix display of negative intervals in SQL and GERMAN datestyles

4 files changed, 9 insertions, 9 deletions

diff --git a/databases/postgresql73-lib/Makefile b/databases/postgresql73-lib/Makefile
index 004f7be389b..01c12c1bbb0 100644
--- a/databases/postgresql73-lib/Makefile
+++ b/databases/postgresql73-lib/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.5 2004/12/18 15:59:55 jlam Exp $
+# $NetBSD: Makefile,v 1.6 2005/02/05 14:49:03 jdolecek Exp $
 
 PKGNAME=		postgresql73-lib-${BASE_VERS}
-PKGREVISION=		1
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgl
 COMMENT=		PostgreSQL database headers and libraries
 
diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
index 410f9ada724..fc001fc2d3e 100644
--- a/databases/postgresql73-server/Makefile
+++ b/databases/postgresql73-server/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.8 2005/02/05 14:47:02 jdolecek Exp $
+# $NetBSD: Makefile,v 1.9 2005/02/05 14:49:03 jdolecek Exp $
 
 PKGNAME=		postgresql73-server-${BASE_VERS}
-PKGREVISION=		4
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgs
 COMMENT=		PostgreSQL database server programs
 
diff --git a/databases/postgresql73/Makefile.common b/databases/postgresql73/Makefile.common
index f07c264d1fc..8862bf332c6 100644
--- a/databases/postgresql73/Makefile.common
+++ b/databases/postgresql73/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.5 2004/10/25 17:40:01 jdolecek Exp $
+# $NetBSD: Makefile.common,v 1.6 2005/02/05 14:49:03 jdolecek Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -33,7 +33,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql73/patches
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
 # Note: Do not forget jdbc-postgresql when updating version
-DIST_VERS?=		7.3.8
+DIST_VERS?=		7.3.9
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_DEPENDS.postgresql73-lib?=	postgresql73-lib>=${BASE_VERS}
diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo
index 79ab984d8a4..d0851086cae 100644
--- a/databases/postgresql73/distinfo
+++ b/databases/postgresql73/distinfo
@@ -1,7 +1,7 @@
-$NetBSD: distinfo,v 1.5 2004/12/18 15:59:55 jlam Exp $
+$NetBSD: distinfo,v 1.6 2005/02/05 14:49:03 jdolecek Exp $
 
-SHA1 (postgresql-7.3.8.tar.gz) = bd27703cbcc219d36521a0e57233408a6f70b342
-Size (postgresql-7.3.8.tar.gz) = 11293472 bytes
+SHA1 (postgresql-7.3.9.tar.gz) = 01481f3af507cb6b361bd71fc51c0fb8c06905da
+Size (postgresql-7.3.9.tar.gz) = 11288172 bytes
 SHA1 (patch-aa) = 61fbeb664b0d89c83a36c79cca3fbdc78d6f5059
 SHA1 (patch-ab) = d45df2da17b1ff67f5f82b4ff743afe350500786
 SHA1 (patch-ac) = 5a647cc31873ae81a5bd5a6cf4ec6f44a43448e7