From c658a3b4f810862bf1cf7fb097de58df35731df0 Mon Sep 17 00:00:00 2001 From: adam Date: Mon, 8 Jan 2007 20:30:42 +0000 Subject: Changes 8.0.10: * Improve handling of getaddrinfo() on AIX This fixes a problem with starting the statistics collector, among other things. * Fix "failed to re-find parent key" errors in "VACUUM" * Fix race condition for truncation of a large relation across a gigabyte boundary by "VACUUM" * Fix bugs affecting multi-gigabyte hash indexes * Fix possible deadlock in Windows signal handling * Fix error when constructing an ARRAY[] made up of multiple empty elements * Fix ecpg memory leak during connection * to_number() and to_char(numeric) are now STABLE, not IMMUTABLE, for new initdb installs This is because lc_numeric can potentially change the output of these functions. * Improve index usage of regular expressions that use parentheses This improves psql \d performance also. * Update timezone database This affects Australian and Canadian daylight-savings rules in particular. --- databases/postgresql80-client/Makefile | 16 ++++++++-------- databases/postgresql80-client/PLIST | 5 ++++- databases/postgresql80-client/buildlink3.mk | 6 +++--- databases/postgresql80-plperl/Makefile | 4 ++-- databases/postgresql80-plpython/Makefile | 4 ++-- databases/postgresql80-pltcl/Makefile | 4 ++-- databases/postgresql80-server/Makefile | 10 +++++----- databases/postgresql80-server/PLIST | 27 ++++++++++++--------------- databases/postgresql80/Makefile.common | 4 ++-- databases/postgresql80/distinfo | 8 ++++---- 10 files changed, 44 insertions(+), 44 deletions(-) (limited to 'databases') diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile index dc2226cab08..2f61c24aec2 100644 --- a/databases/postgresql80-client/Makefile +++ b/databases/postgresql80-client/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.17 2006/10/18 18:39:09 adam Exp $ +# $NetBSD: Makefile,v 1.18 2007/01/08 20:30:42 adam Exp $ PKGNAME= postgresql80-client-${BASE_VERS} COMMENT= PostgreSQL database client programs @@ -11,8 +11,8 @@ CONFIGURE_ARGS+= --with-openssl CONFIGURE_ARGS+= --with-readline CONFIGURE_ARGS+= --with-zlib -CONFLICTS+= postgresql80-lib-* -CONFLICTS+= postgresql80-docs-* +CONFLICTS+= postgresql80-lib-[0-9]* +CONFLICTS+= postgresql80-docs-[0-9]* # 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on # NetBSD (missing strerror_r) or DragonFly. @@ -31,15 +31,15 @@ CONFIGURE_ARGS+= --enable-thread-safety . endif .endif -INSTALL_DIRS= ${WRKSRC}/src/include -INSTALL_DIRS+= ${WRKSRC}/src/interfaces -INSTALL_DIRS+= ${WRKSRC}/src/bin -INSTALL_DIRS+= ${WRKSRC}/doc +INSTALL_DIRS= src/include +INSTALL_DIRS+= src/interfaces +INSTALL_DIRS+= src/bin +INSTALL_DIRS+= doc BUILD_DIRS= ${INSTALL_DIRS} # Without this, the Darwin build fails (related to -bundle_loader). -BUILD_DIRS+= ${WRKSRC}/src/backend +BUILD_DIRS+= src/backend PKG_OPTIONS_VAR= PKG_OPTIONS.postgresql80-client .include "../../databases/postgresql80/options.mk" diff --git a/databases/postgresql80-client/PLIST b/databases/postgresql80-client/PLIST index f4e43741904..158eac4affa 100644 --- a/databases/postgresql80-client/PLIST +++ b/databases/postgresql80-client/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.12 2006/10/18 18:39:09 adam Exp $ +@comment $NetBSD: PLIST,v 1.13 2007/01/08 20:30:42 adam Exp $ ${PG_SUBPREFIX}bin/clusterdb ${PG_SUBPREFIX}bin/createdb ${PG_SUBPREFIX}bin/createlang @@ -948,6 +948,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-13.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-14.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-15.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-16.html +${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-17.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-2.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-3.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-4.html @@ -963,6 +964,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-11.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-12.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-13.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-14.html +${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-15.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 @@ -980,6 +982,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-5.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-6.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-7.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-8.html +${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-9.html ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0.html ${PG_SUBPREFIX}share/doc/postgresql/html/release.html ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html diff --git a/databases/postgresql80-client/buildlink3.mk b/databases/postgresql80-client/buildlink3.mk index 85c73739834..a6cd3affbc3 100644 --- a/databases/postgresql80-client/buildlink3.mk +++ b/databases/postgresql80-client/buildlink3.mk @@ -1,11 +1,11 @@ -# $NetBSD: buildlink3.mk,v 1.8 2006/12/12 21:52:35 joerg Exp $ +# $NetBSD: buildlink3.mk,v 1.9 2007/01/08 20:30:42 adam Exp $ BUILDLINK_DEPTH:= ${BUILDLINK_DEPTH}+ POSTGRESQL80_CLIENT_BUILDLINK3_MK:= ${POSTGRESQL80_CLIENT_BUILDLINK3_MK}+ .include "../../mk/bsd.fast.prefs.mk" -.if !empty(BUILDLINK_DEPTH:M+) +.if ${BUILDLINK_DEPTH} == "+" BUILDLINK_DEPENDS+= postgresql80-client .endif @@ -13,7 +13,7 @@ BUILDLINK_PACKAGES:= ${BUILDLINK_PACKAGES:Npostgresql80-client} BUILDLINK_PACKAGES+= postgresql80-client BUILDLINK_ORDER:= ${BUILDLINK_ORDER} ${BUILDLINK_DEPTH}postgresql80-client -.if !empty(POSTGRESQL80_CLIENT_BUILDLINK3_MK:M+) +.if ${POSTGRESQL80_CLIENT_BUILDLINK3_MK} == "+" BUILDLINK_API_DEPENDS.postgresql80-client+= postgresql80-client>=8.0.2 BUILDLINK_ABI_DEPENDS.postgresql80-client?= postgresql80-client>=8.0.5nb1 BUILDLINK_PKGSRCDIR.postgresql80-client?= ../../databases/postgresql80-client diff --git a/databases/postgresql80-plperl/Makefile b/databases/postgresql80-plperl/Makefile index b9d00347bff..8128fded166 100644 --- a/databases/postgresql80-plperl/Makefile +++ b/databases/postgresql80-plperl/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.6 2006/09/09 02:41:56 obache Exp $ +# $NetBSD: Makefile,v 1.7 2007/01/08 20:30:42 adam Exp $ PKGNAME= postgresql80-plperl-${BASE_VERS} COMMENT= PL/Perl procedural language for the PostgreSQL backend @@ -10,7 +10,7 @@ DEPENDS+= postgresql80-server>=${BASE_VERS}:../../databases/postgresql80-server PERL5_CONFIGURE= NO CONFIGURE_ARGS+= --with-perl -BUILD_DIRS= ${WRKSRC}/src/pl/plperl +BUILD_DIRS= src/pl/plperl MAKE_FILE= GNUmakefile USE_LIBTOOL= yes diff --git a/databases/postgresql80-plpython/Makefile b/databases/postgresql80-plpython/Makefile index a03d80fff35..b37a8be8f7b 100644 --- a/databases/postgresql80-plpython/Makefile +++ b/databases/postgresql80-plpython/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.4 2006/02/21 19:05:07 joerg Exp $ +# $NetBSD: Makefile,v 1.5 2007/01/08 20:30:42 adam Exp $ PKGNAME= postgresql80-plpython-${BASE_VERS} COMMENT= PL/Python procedural language for the PostgreSQL backend @@ -10,7 +10,7 @@ DEPENDS+= postgresql80-server>=${BASE_VERS}:../../databases/postgresql80-server CONFIGURE_ARGS+= --with-python CONFIGURE_ENV+= PYTHON=${PYTHONBIN:Q} -BUILD_DIRS= ${WRKSRC}/src/pl/plpython +BUILD_DIRS= src/pl/plpython USE_LIBTOOL= yes PKG_LIBTOOL= ${PKG_SHLIBTOOL} diff --git a/databases/postgresql80-pltcl/Makefile b/databases/postgresql80-pltcl/Makefile index e20a0c797dc..2c10d5b4d16 100644 --- a/databases/postgresql80-pltcl/Makefile +++ b/databases/postgresql80-pltcl/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.4 2006/02/21 19:05:07 joerg Exp $ +# $NetBSD: Makefile,v 1.5 2007/01/08 20:30:42 adam Exp $ PKGNAME= postgresql80-pltcl-${BASE_VERS} COMMENT= PL/Tcl procedural language for the PostgreSQL backend @@ -12,7 +12,7 @@ CONFIGURE_ARGS+= --with-tclconfig="${BUILDLINK_PREFIX.tcl}/lib" CONFIGURE_ENV+= TCLSH=${TCLSH:Q} TCLSH= ${BUILDLINK_PREFIX.tcl}/bin/tclsh -BUILD_DIRS= ${WRKSRC}/src/pl/tcl +BUILD_DIRS= src/pl/tcl USE_LIBTOOL= yes PKG_LIBTOOL= ${PKG_SHLIBTOOL} diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile index ad44d4c4532..b4b5566b0ca 100644 --- a/databases/postgresql80-server/Makefile +++ b/databases/postgresql80-server/Makefile @@ -1,4 +1,4 @@ -# $NetBSD: Makefile,v 1.22 2006/10/18 18:39:19 adam Exp $ +# $NetBSD: Makefile,v 1.23 2007/01/08 20:30:42 adam Exp $ PKGNAME= postgresql80-server-${BASE_VERS} COMMENT= PostgreSQL database server programs @@ -16,10 +16,10 @@ MESSAGE_SRC= ${.CURDIR}/MESSAGE CONFIGURE_ARGS+= --with-openssl -BUILD_DIRS= ${WRKSRC}/src/backend -BUILD_DIRS+= ${WRKSRC}/src/backend/utils/mb/conversion_procs -BUILD_DIRS+= ${WRKSRC}/src/timezone -BUILD_DIRS+= ${WRKSRC}/src/pl +BUILD_DIRS= src/backend +BUILD_DIRS+= src/backend/utils/mb/conversion_procs +BUILD_DIRS+= src/timezone +BUILD_DIRS+= src/pl # PostgreSQL has loadable server-side language modules. # diff --git a/databases/postgresql80-server/PLIST b/databases/postgresql80-server/PLIST index d58a4c5a55a..4546a613dec 100644 --- a/databases/postgresql80-server/PLIST +++ b/databases/postgresql80-server/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.7 2005/10/23 20:16:52 jlam Exp $ +@comment $NetBSD: PLIST,v 1.8 2007/01/08 20:30:42 adam Exp $ ${PG_SUBPREFIX}bin/postgres ${PG_SUBPREFIX}bin/postmaster ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la @@ -129,10 +129,12 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Ushuaia ${PG_SUBPREFIX}share/postgresql/timezone/America/Aruba ${PG_SUBPREFIX}share/postgresql/timezone/America/Asuncion ${PG_SUBPREFIX}share/postgresql/timezone/America/Atka +${PG_SUBPREFIX}share/postgresql/timezone/America/Atikokan ${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia ${PG_SUBPREFIX}share/postgresql/timezone/America/Barbados ${PG_SUBPREFIX}share/postgresql/timezone/America/Belem ${PG_SUBPREFIX}share/postgresql/timezone/America/Belize +${PG_SUBPREFIX}share/postgresql/timezone/America/Blanc-Sablon ${PG_SUBPREFIX}share/postgresql/timezone/America/Boa_Vista ${PG_SUBPREFIX}share/postgresql/timezone/America/Bogota ${PG_SUBPREFIX}share/postgresql/timezone/America/Boise @@ -178,7 +180,9 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Hermosillo ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Indianapolis ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Knox ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Marengo +${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Petersburg ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vevay +${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vincennes ${PG_SUBPREFIX}share/postgresql/timezone/America/Indianapolis ${PG_SUBPREFIX}share/postgresql/timezone/America/Inuvik ${PG_SUBPREFIX}share/postgresql/timezone/America/Iqaluit @@ -202,6 +206,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Menominee ${PG_SUBPREFIX}share/postgresql/timezone/America/Merida ${PG_SUBPREFIX}share/postgresql/timezone/America/Mexico_City ${PG_SUBPREFIX}share/postgresql/timezone/America/Miquelon +${PG_SUBPREFIX}share/postgresql/timezone/America/Moncton ${PG_SUBPREFIX}share/postgresql/timezone/America/Monterrey ${PG_SUBPREFIX}share/postgresql/timezone/America/Montevideo ${PG_SUBPREFIX}share/postgresql/timezone/America/Montreal @@ -212,6 +217,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Nipigon ${PG_SUBPREFIX}share/postgresql/timezone/America/Nome ${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/Panama ${PG_SUBPREFIX}share/postgresql/timezone/America/Pangnirtung ${PG_SUBPREFIX}share/postgresql/timezone/America/Paramaribo @@ -453,8 +459,11 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Chisinau ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Copenhagen ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Dublin ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Gibraltar +${PG_SUBPREFIX}share/postgresql/timezone/Europe/Guernsey ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Helsinki +${PG_SUBPREFIX}share/postgresql/timezone/Europe/Isle_of_Man ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Istanbul +${PG_SUBPREFIX}share/postgresql/timezone/Europe/Jersey ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kaliningrad ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Kiev ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Lisbon @@ -470,6 +479,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Moscow ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Nicosia ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Oslo ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Paris +${PG_SUBPREFIX}share/postgresql/timezone/Europe/Podgorica ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Prague ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Riga ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Rome @@ -488,6 +498,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vaduz ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vatican ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vienna ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Vilnius +${PG_SUBPREFIX}share/postgresql/timezone/Europe/Volgograd ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Warsaw ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zagreb ${PG_SUBPREFIX}share/postgresql/timezone/Europe/Zaporozhye @@ -579,19 +590,6 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Portugal ${PG_SUBPREFIX}share/postgresql/timezone/ROC ${PG_SUBPREFIX}share/postgresql/timezone/ROK ${PG_SUBPREFIX}share/postgresql/timezone/Singapore -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/AST4 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/AST4ADT -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/CST6 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/CST6CDT -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/EST5 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/EST5EDT -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/HST10 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/MST7 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/MST7MDT -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/PST8 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/PST8PDT -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/YST9 -${PG_SUBPREFIX}share/postgresql/timezone/SystemV/YST9YDT ${PG_SUBPREFIX}share/postgresql/timezone/Turkey ${PG_SUBPREFIX}share/postgresql/timezone/UCT ${PG_SUBPREFIX}share/postgresql/timezone/US/Alaska @@ -613,7 +611,6 @@ ${PG_SUBPREFIX}share/postgresql/timezone/W-SU ${PG_SUBPREFIX}share/postgresql/timezone/WET ${PG_SUBPREFIX}share/postgresql/timezone/Zulu @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/US -@dirrm ${PG_SUBPREFIX}share/postgresql/timezone/SystemV @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Pacific @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Mideast @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Mexico diff --git a/databases/postgresql80/Makefile.common b/databases/postgresql80/Makefile.common index c5561c0341c..6aaf54fad9f 100644 --- a/databases/postgresql80/Makefile.common +++ b/databases/postgresql80/Makefile.common @@ -1,4 +1,4 @@ -# $NetBSD: Makefile.common,v 1.24 2006/10/18 18:38:57 adam Exp $ +# $NetBSD: Makefile.common,v 1.25 2007/01/08 20:30:42 adam Exp $ # # This Makefile fragment is included by all PostgreSQL packages built from # the main sources of the PostgreSQL distribution except jdbc-postgresql. @@ -35,7 +35,7 @@ PATCHDIR?= ${.CURDIR}/../postgresql80/patches # # Note: Do not forget jdbc-postgresql80 when updating version # -DIST_VERS?= 8.0.9 +DIST_VERS?= 8.0.10 BASE_VERS?= ${DIST_VERS} BUILDLINK_API_DEPENDS.postgresql80-client+= postgresql80-client>=${BASE_VERS} diff --git a/databases/postgresql80/distinfo b/databases/postgresql80/distinfo index e5fa2ba06de..2646ff8bb37 100644 --- a/databases/postgresql80/distinfo +++ b/databases/postgresql80/distinfo @@ -1,8 +1,8 @@ -$NetBSD: distinfo,v 1.14 2006/10/18 18:38:57 adam Exp $ +$NetBSD: distinfo,v 1.15 2007/01/08 20:30:42 adam Exp $ -SHA1 (postgresql-8.0.9.tar.bz2) = 75caa1c25e651727297e03726bbf09e453c06180 -RMD160 (postgresql-8.0.9.tar.bz2) = 365598898a4d71bfa001bb7eebabc91825ff2273 -Size (postgresql-8.0.9.tar.bz2) = 11161142 bytes +SHA1 (postgresql-8.0.10.tar.bz2) = 5b89d376cc83bf00b1acfe056a59f02e1c7e430a +RMD160 (postgresql-8.0.10.tar.bz2) = b07bf765f7bffda63272da28efce646846e4779c +Size (postgresql-8.0.10.tar.bz2) = 11164508 bytes SHA1 (patch-aa) = d681a5b2bb4dfce4e3db1490b97fed1b99ff445f SHA1 (patch-ab) = 1a80710d13723f2c8130d8235bb40c43af9d9ccd SHA1 (patch-ac) = 092d96fe2baafe8eef731b45a85d33fc40584044 -- cgit v1.2.3