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.

2 files changed, 17 insertions, 20 deletions

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