[pkgsrc/trunk]: pkgsrc/databases Update to postgresql 7.3.9. This release con...

[jdolecek <jdolecek%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/6a7d37207a45
branches:  trunk
changeset: 488646:6a7d37207a45
user:      jdolecek <jdolecek%pkgsrc.org@localhost>
date:      Sat Feb 05 14:49:03 2005 +0000

description:
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

diffstat:

 databases/postgresql73-lib/Makefile    |  4 ++--
 databases/postgresql73-server/Makefile |  4 ++--
 databases/postgresql73/Makefile.common |  4 ++--
 databases/postgresql73/distinfo        |  6 +++---
 4 files changed, 9 insertions(+), 9 deletions(-)

diffs (58 lines):

diff -r 31c689ad912a -r 6a7d37207a45 databases/postgresql73-lib/Makefile
--- a/databases/postgresql73-lib/Makefile       Sat Feb 05 14:47:02 2005 +0000
+++ b/databases/postgresql73-lib/Makefile       Sat Feb 05 14:49:03 2005 +0000
@@ -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 -r 31c689ad912a -r 6a7d37207a45 databases/postgresql73-server/Makefile
--- a/databases/postgresql73-server/Makefile    Sat Feb 05 14:47:02 2005 +0000
+++ b/databases/postgresql73-server/Makefile    Sat Feb 05 14:49:03 2005 +0000
@@ -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 -r 31c689ad912a -r 6a7d37207a45 databases/postgresql73/Makefile.common
--- a/databases/postgresql73/Makefile.common    Sat Feb 05 14:47:02 2005 +0000
+++ b/databases/postgresql73/Makefile.common    Sat Feb 05 14:49:03 2005 +0000
@@ -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 @@
 # 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 -r 31c689ad912a -r 6a7d37207a45 databases/postgresql73/distinfo
--- a/databases/postgresql73/distinfo   Sat Feb 05 14:47:02 2005 +0000
+++ b/databases/postgresql73/distinfo   Sat Feb 05 14:49:03 2005 +0000
@@ -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