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.

10 files changed, 44 insertions, 44 deletions

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