pkgsrc-Changes-HG archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

[pkgsrc/trunk]: pkgsrc/databases Changes 8.3.10:



details:   https://anonhg.NetBSD.org/pkgsrc/rev/b1538a6e3f10
branches:  trunk
changeset: 574232:b1538a6e3f10
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Apr 12 09:53:50 2010 +0000

description:
Changes 8.3.10:
* Add new configuration parameter ssl_renegotiation_limit to control
  how often we do session key renegotiation for an SSL connection
* Fix possible deadlock during backend startup
* Fix possible crashes due to not handling errors during relcache
  reload cleanly
* Fix possible crash due to use of dangling pointer to a cached plan
* Fix possible crashes when trying to recover from a failure in
  subtransaction start
* Fix server memory leak associated with use of savepoints and a
  client encoding different from server's encoding
* Fix incorrect WAL data emitted during end-of-recovery cleanup of a
  GIST index page split
* Make substring() for bit types treat any negative length as meaning
  "all the rest of the string"
  The previous coding treated only -1 that way, and would produce an
  invalid result value for other negative values, possibly leading to
  a crash (CVE-2010-0442).
* Fix integer-to-bit-string conversions to handle the first
  fractional byte correctly when the output bit width is wider than
  the given integer by something other than a multiple of 8 bits
* Fix some cases of pathologically slow regular expression matching
* Fix assorted crashes in xml processing caused by sloppy memory
  management
* Fix bug with trying to update a field of an element of a
  composite-type array column
* Fix the STOP WAL LOCATION entry in backup history files to report
  the next WAL segment's name when the end location is exactly at a
  segment boundary
* Fix some more cases of temporary-file leakage
  This corrects a problem introduced in the previous minor release.
  One case that failed is when a plpgsql function returning set is
  called within another function's exception handler.
* Improve constraint exclusion processing of boolean-variable cases,
  in particular make it possible to exclude a partition that has a
  "bool_column = false" constraint
* When reading "pg_hba.conf" and related files, do not treat
  @something as a file inclusion request if the @ appears inside
  quote marks; also, never treat @ by itself as a file inclusion
  request
* Prevent infinite loop on some platforms if a directory is named as
  an inclusion target in "pg_hba.conf" and related files
* Fix possible infinite loop if SSL_read or SSL_write fails without
  setting errno
  This is reportedly possible with some Windows versions of openssl.
* Disallow GSSAPI authentication on local connections, since it
  requires a hostname to function correctly
* Make ecpg report the proper SQLSTATE if the connection disappears
* Fix psql's numericlocale option to not format strings it shouldn't
  in latex and troff output formats
* Make psql return the correct exit status (3) when ON_ERROR_STOP and
  --single-transaction are both specified and an error occurs during
  the implied "COMMIT"
* Fix plpgsql failure in one case where a composite column is set to NULL
* Fix possible failure when calling PL/Perl functions from PL/PerlU
  or vice versa
* Add volatile markings in PL/Python to avoid possible
  compiler-specific misbehavior
* Ensure PL/Tcl initializes the Tcl interpreter fully
  The only known symptom of this oversight is that the Tcl clock
  command misbehaves if using Tcl 8.5 or later.
* Prevent crash in "contrib/dblink" when too many key columns are
  specified to a dblink_build_sql_* function
* Allow zero-dimensional arrays in "contrib/ltree" operations
* Fix assorted crashes in "contrib/xml2" caused by sloppy memory
  management
* Make building of "contrib/xml2" more robust on Windows
* Fix race condition in Windows signal handling
  One known symptom of this bug is that rows in pg_listener could be
  dropped under heavy load.
* Update time zone data files to tzdata release 2010e for DST law
  changes in Bangladesh, Chile, Fiji, Mexico, Paraguay, Samoa.

diffstat:

 databases/postgresql83-adminpack/Makefile |   3 +-
 databases/postgresql83-client/Makefile    |   4 +-
 databases/postgresql83-plperl/Makefile    |   3 +-
 databases/postgresql83-plpython/Makefile  |   3 +-
 databases/postgresql83-pltcl/Makefile     |   3 +-
 databases/postgresql83-server/Makefile    |   7 +--
 databases/postgresql83-server/PLIST       |   5 +-
 databases/postgresql83/Makefile.common    |  77 +++++++++---------------------
 databases/postgresql83/distinfo           |  10 +--
 databases/postgresql83/patches/patch-ad   |  78 -------------------------------
 databases/postgresql83/patches/patch-ae   |  45 -----------------
 11 files changed, 37 insertions(+), 201 deletions(-)

diffs (truncated from 428 to 300 lines):

diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-adminpack/Makefile
--- a/databases/postgresql83-adminpack/Makefile Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-adminpack/Makefile Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2010/01/17 12:02:11 wiz Exp $
+# $NetBSD: Makefile,v 1.4 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-adminpack-${BASE_VERS}
-PKGREVISION=   1
 COMMENT=       Admin pack module for pgAdmin management
 
 PKG_DESTDIR_SUPPORT=   user-destdir
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-client/Makefile
--- a/databases/postgresql83-client/Makefile    Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-client/Makefile    Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2010/01/21 12:45:28 adam Exp $
+# $NetBSD: Makefile,v 1.13 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-client-${BASE_VERS}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=   user-destdir
@@ -17,7 +16,6 @@
 # 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on
 # NetBSD earler than 4.0 or DragonFly.
 # 2. configure with --enable-thread-safety fails on OpenBSD.
-#
 .if (${OPSYS} == "NetBSD" && !empty(OS_VERSION:M[0-3].*)) || \
     ${OPSYS} == "DragonFly" || ${OPSYS} == "OpenBSD"
 PGSQL_THREAD_SAFETY?=  no
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-plperl/Makefile
--- a/databases/postgresql83-plperl/Makefile    Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-plperl/Makefile    Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2010/01/17 12:02:11 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-plperl-${BASE_VERS}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=   user-destdir
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-plpython/Makefile
--- a/databases/postgresql83-plpython/Makefile  Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-plpython/Makefile  Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2010/02/10 19:17:34 joerg Exp $
+# $NetBSD: Makefile,v 1.7 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-plpython-${BASE_VERS}
-PKGREVISION=   2
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=   user-destdir
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-pltcl/Makefile
--- a/databases/postgresql83-pltcl/Makefile     Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-pltcl/Makefile     Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2010/01/17 12:02:11 wiz Exp $
+# $NetBSD: Makefile,v 1.4 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-pltcl-${BASE_VERS}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=   user-destdir
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-server/Makefile
--- a/databases/postgresql83-server/Makefile    Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-server/Makefile    Mon Apr 12 09:53:50 2010 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2010/01/22 20:12:11 adam Exp $
+# $NetBSD: Makefile,v 1.11 2010/04/12 09:53:50 adam Exp $
 
 PKGNAME=       postgresql83-server-${BASE_VERS}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database server programs
 
 PKG_DESTDIR_SUPPORT=   user-destdir
@@ -32,7 +31,6 @@
 # PostgreSQL's backend (pkg/28729).  This works on older and newer
 # versions of NetBSD as well since they don't have the bad interaction
 # between dlopen() and pthreads.
-#
 .if ${OPSYS} == "NetBSD"
 DLOPEN_REQUIRE_PTHREADS=       no
 .endif
@@ -40,7 +38,6 @@
 
 # If we're using libltdl to provide "dlopen" functionality, then add the
 # dependency and make sure that we link against -lltdl.
-#
 .if !empty(USE_LIBLTDL:M[yY][eE][sS])
 DL_LIBS+=      -lltdl
 .  include "../../devel/libltdl/buildlink3.mk"
@@ -54,7 +51,6 @@
 # PGGROUP      group of the database administrator
 # PGHOME       home directory of the database administrator and location of
 #              the databases
-#
 PGUSER?=               pgsql
 PGGROUP?=              pgsql
 PGHOME?=               ${PREFIX}/${PGUSER}
@@ -79,7 +75,6 @@
 
 # Avoid conflict between "${SSLBASE}/include/openssl/des.h" and
 # "/usr/include/crypt.h" -- we want the definitions in the former.
-#
 post-wrapper:
 .if ${OPSYS} == "SunOS"
        touch ${BUILDLINK_DIR}/include/crypt.h
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83-server/PLIST
--- a/databases/postgresql83-server/PLIST       Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83-server/PLIST       Mon Apr 12 09:53:50 2010 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2010/01/21 12:45:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2010/04/12 09:53:50 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -211,6 +211,7 @@
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Manaus
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Marigot
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Martinique
+${PG_SUBPREFIX}share/postgresql/timezone/America/Matamoros
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Mazatlan
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Mendoza
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Menominee
@@ -229,6 +230,7 @@
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Noronha
 ${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/Center
 ${PG_SUBPREFIX}share/postgresql/timezone/America/North_Dakota/New_Salem
+${PG_SUBPREFIX}share/postgresql/timezone/America/Ojinaga
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Panama
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Pangnirtung
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Paramaribo
@@ -247,6 +249,7 @@
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Rosario
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santarem
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santiago
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santa_Isabel
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santo_Domingo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Sao_Paulo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Scoresbysund
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83/Makefile.common
--- a/databases/postgresql83/Makefile.common    Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83/Makefile.common    Mon Apr 12 09:53:50 2010 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.9 2009/12/16 14:23:13 adam Exp $
+# $NetBSD: Makefile.common,v 1.10 2010/04/12 09:53:50 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -32,13 +32,10 @@
 PATCHDIR?=             ${.CURDIR}/../postgresql83/patches
 
 # Version numbering scheme:
-#
 # DIST_VERS            version number on the postgresql distfile
 # BASE_VERS            pkgsrc-mangled version number (convert pl -> .)
-#
 # Note: Do not forget jdbc-postgresql83 when updating version
-#
-DIST_VERS?=            8.3.9
+DIST_VERS?=            8.3.10
 BASE_VERS?=            ${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql83-client+=    postgresql83-client>=${BASE_VERS}
@@ -56,10 +53,10 @@
 
 .include "../../mk/bsd.prefs.mk"
 
-PGSQL_TEMPLATE.SunOS=          solaris
-PGSQL_TEMPLATE.IRIX=           irix5
-.if !defined(PGSQL_TEMPLATE.${OPSYS})
-PGSQL_TEMPLATE.${OPSYS}=       ${LOWER_OPSYS}
+PG_TEMPLATE.SunOS=     solaris
+PG_TEMPLATE.IRIX=      irix5
+.if !defined(PG_TEMPLATE.${OPSYS})
+PG_TEMPLATE.${OPSYS}=  ${LOWER_OPSYS}
 .endif
 
 PG_SUBPREFIX=          # empty
@@ -81,7 +78,7 @@
 CONFIGURE_ARGS+=       --sysconfdir=${PG_ETC_DIR}
 CONFIGURE_ARGS+=       --datadir=${PG_DATA_DIR}
 CONFIGURE_ARGS+=       --with-docdir=${PG_DOC_DIR}
-CONFIGURE_ARGS+=       --with-template=${PGSQL_TEMPLATE.${OPSYS}}
+CONFIGURE_ARGS+=       --with-template=${PG_TEMPLATE.${OPSYS}}
 CONFIGURE_ARGS+=       --without-readline
 CONFIGURE_ARGS+=       --without-zlib
 CONFIGURE_ARGS+=       --enable-nls
@@ -100,7 +97,6 @@
 
 # USE_LIBLTDL is "yes" or "no" depending on whether we're using libltdl
 # to provide "dlopen" functionality for the PostgreSQL backend.
-#
 .if ${OPSYS} == "Interix"
 USE_LIBLTDL?=          yes
 .endif
@@ -111,58 +107,31 @@
 .include "../../devel/gettext-lib/buildlink3.mk"
 
 post-extract:
-       if ${TEST} -d ${WRKSRC}/src; then                               \
-               rm -f ${WRKSRC}/src/Makefile.custom;                    \
-               cp -f ${COMMON_FILESDIR}/Makefile.custom                \
-                       ${WRKSRC}/src/Makefile.custom;                  \
-               rm -f ${WRKSRC}/src/Makefile.shlib;                     \
-               cp -f ${COMMON_FILESDIR}/Makefile.libtool               \
-                       ${WRKSRC}/src/Makefile.shlib;                   \
-       fi
-       if ${TEST} -d ${WRKSRC}/src/interfaces/libpq; then              \
-               rm -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile;       \
-               cp -f ${COMMON_FILESDIR}/GNUmakefile.libpq              \
-                       ${WRKSRC}/src/interfaces/libpq/GNUmakefile;     \
-       fi
-       if ${TEST} -d ${WRKSRC}/src/interfaces/libpgtcl; then           \
-               rm -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;    \
-               cp -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl   \
-                       ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;  \
-       fi
+       cp -f ${COMMON_FILESDIR}/Makefile.custom ${WRKSRC}/src/Makefile.custom
+       cp -f ${COMMON_FILESDIR}/Makefile.libtool ${WRKSRC}/src/Makefile.shlib
 .if !empty(USE_LIBLTDL:M[yY][eE][sS])
-       if ${TEST} -d ${WRKSRC}/src/backend/port/dynloader; then        \
-               template=${PGSQL_TEMPLATE.${OPSYS}:Q};                  \
-               rm -f ${WRKSRC}/src/backend/port/dynloader/$$template.[ch]; \
-               cp -f ${COMMON_FILESDIR}/dynloader-ltdl.h               \
-                       ${WRKSRC}/src/backend/port/dynloader/$$template.h; \
-               ${ECHO} "static int dummy = 0;"                         \
-                        >${WRKSRC}/src/backend/port/dynloader/$$template.c
+               template=${PG_TEMPLATE.${OPSYS}:Q}
+       cp -f ${COMMON_FILESDIR}/dynloader-ltdl.h \
+               ${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.h
+       ${ECHO} "static int dummy = 0;" \
+               > ${WRKSRC}/src/backend/port/dynloader/${PG_TEMPLATE.${OPSYS}:Q}.c
        fi
 .endif
-       if ${TEST} -d ${WRKSRC}/src/template; then                      \
-               touch ${WRKSRC}/src/template/dragonfly;         \
-       fi
-       if ${TEST} -d ${WRKSRC}/src/backend/port/dynloader; then        \
-               cp ${WRKSRC}/src/backend/port/dynloader/freebsd.c       \
-                       ${WRKSRC}/src/backend/port/dynloader/dragonfly.c; \
-               cp ${WRKSRC}/src/backend/port/dynloader/freebsd.h       \
-                       ${WRKSRC}/src/backend/port/dynloader/dragonfly.h; \
-       fi
-       if ${TEST} -d ${WRKSRC}/src/include/port; then                  \
-               cp ${WRKSRC}/src/include/port/freebsd.h         \
-                       ${WRKSRC}/src/include/port/dragonfly.h;         \
-       fi
-       if ${TEST} -d ${WRKSRC}/src/makefiles; then                     \
-               cp ${WRKSRC}/src/makefiles/Makefile.freebsd             \
-                       ${WRKSRC}/src/makefiles/Makefile.dragonfly;     \
-       fi
+       touch ${WRKSRC}/src/template/dragonfly
+       cp ${WRKSRC}/src/backend/port/dynloader/freebsd.c \
+               ${WRKSRC}/src/backend/port/dynloader/dragonfly.c
+       cp ${WRKSRC}/src/backend/port/dynloader/freebsd.h \
+               ${WRKSRC}/src/backend/port/dynloader/dragonfly.h
+       cp ${WRKSRC}/src/include/port/freebsd.h \
+               ${WRKSRC}/src/include/port/dragonfly.h
+       cp ${WRKSRC}/src/makefiles/Makefile.freebsd \
+               ${WRKSRC}/src/makefiles/Makefile.dragonfly
 
 # PGSQL_BLCKSZ is the size in bytes of a PostgreSQL disk page or block.
 # This also limits the size of a tuple.  The valid values are powers
 # of 2 up to 32768, and the default size is 8196 (hardcoded in the
 # PostgreSQL sources).  Please don't change this value unless you know
 # what you are doing.
-#
 BUILD_DEFS+=   PGSQL_BLCKSZ
 
 .if defined(PGSQL_BLCKSZ)
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83/distinfo
--- a/databases/postgresql83/distinfo   Mon Apr 12 09:48:48 2010 +0000
+++ b/databases/postgresql83/distinfo   Mon Apr 12 09:53:50 2010 +0000
@@ -1,13 +1,11 @@
-$NetBSD: distinfo,v 1.10 2010/01/21 12:45:28 adam Exp $
+$NetBSD: distinfo,v 1.11 2010/04/12 09:53:50 adam Exp $
 
-SHA1 (postgresql-8.3.9.tar.bz2) = 5403f13bb14fe568e2b46a3350d6e28808d93a2c
-RMD160 (postgresql-8.3.9.tar.bz2) = 0069606033d9572d7848a5914a274cabaed24007
-Size (postgresql-8.3.9.tar.bz2) = 14170569 bytes
+SHA1 (postgresql-8.3.10.tar.bz2) = 2ad430f4349eb42fbfe21a6a80a493f4068b519e
+RMD160 (postgresql-8.3.10.tar.bz2) = 12bb4ac6d0b0e53534582c7e4092bf91092e9345
+Size (postgresql-8.3.10.tar.bz2) = 14181794 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279
-SHA1 (patch-ad) = 5612e447bbb76e81f72d39ad0153b9f77d47f653
-SHA1 (patch-ae) = 8b3e47320dfe05d94b769c9b079fd7ca6d26f5d6
 SHA1 (patch-af) = fcb43276c1f3349f62acfc37ac0bd6ccaae96f29
 SHA1 (patch-ag) = 402d5d211af99efdfa35677299c97e91e14ed85d
 SHA1 (patch-ah) = 3640573195f66a46c37d9fca2648d6be39f5593b
diff -r 57b3a95f4387 -r b1538a6e3f10 databases/postgresql83/patches/patch-ad
--- a/databases/postgresql83/patches/patch-ad   Mon Apr 12 09:48:48 2010 +0000
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000



Home | Main Index | Thread Index | Old Index