Changes 8.4.8:

* fix build issues on HP-UX and Itanium
* update time zone files for recent time zone changes
* change SQLSTATE for Hot Standby warnings
* prevent bgwriter hang during recovery
* prevent recursive composite type creation
* disallow dropping tables whose triggers are still pending
* allow use of "replication" as a user name
* prevent a crash during GEQO planning
* improve join plans for tables with missing statistics
* fix error with SELECT FOR UPDATE in a subselect
* close PL/python array slice memory leak
* allow SSL connections for users with no home directory

8 files changed, 27 insertions, 18 deletions

diff --git a/databases/postgresql84-adminpack/Makefile b/databases/postgresql84-adminpack/Makefile
index b2e1a64e91b..e4a097e5f44 100644
--- a/databases/postgresql84-adminpack/Makefile
+++ b/databases/postgresql84-adminpack/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.5 2011/02/15 08:14:15 adam Exp $
+# $NetBSD: Makefile,v 1.6 2011/04/22 13:01:30 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-adminpack-/}
 COMMENT=	Admin pack module for pgAdmin management
@@ -9,8 +9,9 @@ DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-
 
 .include "../../databases/postgresql84/Makefile.common"
 
-BUILD_DIRS=		contrib/adminpack
 BUILD_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS=		contrib/adminpack
 REQD_DIRS+=		share/doc/postgresql/contrib
 REQD_DIRS+=		share/postgresql/contrib
 
diff --git a/databases/postgresql84-client/Makefile b/databases/postgresql84-client/Makefile
index 235bcc92f11..c572fd4fb69 100644
--- a/databases/postgresql84-client/Makefile
+++ b/databases/postgresql84-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.13 2011/02/15 08:14:16 adam Exp $
+# $NetBSD: Makefile,v 1.14 2011/04/22 13:01:30 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-client-/}
 COMMENT=	PostgreSQL database client programs
@@ -79,8 +79,8 @@ post-wrapper:
 .endif
 
 post-install:
-	set -e; for file in ${PGXS_FILES}; do				\
-		${INSTALL_DATA} ${WRKSRC}/$$file ${DEST_PGXS}/$$file;	\
-	done
+.for file in ${PGXS_FILES}
+	${INSTALL_DATA} ${WRKSRC}/${file} ${DEST_PGXS}/${file}
+.endfor
 
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index e269da8ccdf..ee8f0210a17 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2011/02/15 08:14:16 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2011/04/22 13:01:30 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -70,6 +70,7 @@ include/postgresql/server/access/slru.h
 include/postgresql/server/access/subtrans.h
 include/postgresql/server/access/sysattr.h
 include/postgresql/server/access/transam.h
+include/postgresql/server/access/tupconvert.h
 include/postgresql/server/access/tupdesc.h
 include/postgresql/server/access/tupmacs.h
 include/postgresql/server/access/tuptoaster.h
@@ -1311,6 +1312,7 @@ share/doc/postgresql/html/release-8-2-18.html
 share/doc/postgresql/html/release-8-2-19.html
 share/doc/postgresql/html/release-8-2-2.html
 share/doc/postgresql/html/release-8-2-20.html
+share/doc/postgresql/html/release-8-2-21.html
 share/doc/postgresql/html/release-8-2-3.html
 share/doc/postgresql/html/release-8-2-4.html
 share/doc/postgresql/html/release-8-2-5.html
@@ -1325,6 +1327,7 @@ share/doc/postgresql/html/release-8-3-11.html
 share/doc/postgresql/html/release-8-3-12.html
 share/doc/postgresql/html/release-8-3-13.html
 share/doc/postgresql/html/release-8-3-14.html
+share/doc/postgresql/html/release-8-3-15.html
 share/doc/postgresql/html/release-8-3-2.html
 share/doc/postgresql/html/release-8-3-3.html
 share/doc/postgresql/html/release-8-3-4.html
@@ -1341,6 +1344,7 @@ share/doc/postgresql/html/release-8-4-4.html
 share/doc/postgresql/html/release-8-4-5.html
 share/doc/postgresql/html/release-8-4-6.html
 share/doc/postgresql/html/release-8-4-7.html
+share/doc/postgresql/html/release-8-4-8.html
 share/doc/postgresql/html/release-8-4.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql84-dblink/Makefile b/databases/postgresql84-dblink/Makefile
index 10e76fddd6d..44bc613df4a 100644
--- a/databases/postgresql84-dblink/Makefile
+++ b/databases/postgresql84-dblink/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.3 2011/02/15 08:14:16 adam Exp $
+# $NetBSD: Makefile,v 1.4 2011/04/22 13:01:30 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-dblink-/}
 COMMENT=	dblink module for remote database connections
@@ -10,9 +10,10 @@ DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-
 .include "../../databases/postgresql84/Makefile.common"
 
 CONFIGURE_ARGS+=	--with-openssl
+BUILD_MAKE_FLAGS=	PGXS=1
+
 BUILD_DIRS=		src/interfaces/libpq
 BUILD_DIRS+=		contrib/dblink
-BUILD_MAKE_FLAGS=	PGXS=1
 INSTALL_DIRS=		contrib/dblink
 REQD_DIRS+=		share/doc/postgresql/contrib
 REQD_DIRS+=		share/postgresql/contrib
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 90e62858e4e..8103070cacb 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2011/03/05 14:24:33 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2011/04/22 13:01:31 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-server/PLIST b/databases/postgresql84-server/PLIST
index 6a2de5e83f4..61a948cf3b8 100644
--- a/databases/postgresql84-server/PLIST
+++ b/databases/postgresql84-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2011/02/15 08:14:17 adam Exp $
+@comment $NetBSD: PLIST,v 1.9 2011/04/22 13:01:31 adam Exp $
 bin/postgres
 bin/postmaster
 lib/postgresql/ascii_and_mic.so
@@ -215,6 +215,7 @@ share/postgresql/timezone/America/Mazatlan
 share/postgresql/timezone/America/Mendoza
 share/postgresql/timezone/America/Menominee
 share/postgresql/timezone/America/Merida
+share/postgresql/timezone/America/Metlakatla
 share/postgresql/timezone/America/Mexico_City
 share/postgresql/timezone/America/Miquelon
 share/postgresql/timezone/America/Moncton
@@ -227,6 +228,7 @@ share/postgresql/timezone/America/New_York
 share/postgresql/timezone/America/Nipigon
 share/postgresql/timezone/America/Nome
 share/postgresql/timezone/America/Noronha
+share/postgresql/timezone/America/North_Dakota/Beulah
 share/postgresql/timezone/America/North_Dakota/Center
 share/postgresql/timezone/America/North_Dakota/New_Salem
 share/postgresql/timezone/America/Ojinaga
@@ -253,6 +255,7 @@ share/postgresql/timezone/America/Santo_Domingo
 share/postgresql/timezone/America/Sao_Paulo
 share/postgresql/timezone/America/Scoresbysund
 share/postgresql/timezone/America/Shiprock
+share/postgresql/timezone/America/Sitka
 share/postgresql/timezone/America/St_Barthelemy
 share/postgresql/timezone/America/St_Johns
 share/postgresql/timezone/America/St_Kitts
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index 673a24ee254..ef50d9d6442 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.11 2011/02/15 08:14:15 adam Exp $
+# $NetBSD: Makefile.common,v 1.12 2011/04/22 13:01:30 adam Exp $
 #
 # used by databases/postgresql84-adminpack/Makefile
 # used by databases/postgresql84-client/Makefile
@@ -19,13 +19,14 @@
 
 .include "../../databases/postgresql84/Makefile.mirrors"
 
-DISTNAME=	postgresql-8.4.7
+DISTNAME=	postgresql-8.4.8
 CATEGORIES=	databases
 MASTER_SITES=	${PGSQL_MIRRORS:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
 
 MAINTAINER?=	adam@NetBSD.org
 HOMEPAGE=	http://www.postgresql.org/
+LICENSE=	postgresql-license
 
 CONFLICTS+=	postgresql-[0-9]*
 CONFLICTS+=	postgresql7[0-9]-*
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index d491bedf5ed..1ab826ecb31 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.10 2011/02/15 08:14:15 adam Exp $
+$NetBSD: distinfo,v 1.11 2011/04/22 13:01:30 adam Exp $
 
-SHA1 (postgresql-8.4.7.tar.bz2) = 078c2fc6c3e7d6832012eab790de805ea6526060
-RMD160 (postgresql-8.4.7.tar.bz2) = 15721cddd4ee916d44ed7e656c0570ef4cb6c102
-Size (postgresql-8.4.7.tar.bz2) = 14133535 bytes
+SHA1 (postgresql-8.4.8.tar.bz2) = f4936de8b8a31f5579e094c928df9612fffe62b5
+RMD160 (postgresql-8.4.8.tar.bz2) = ad4c81e7f22ed3018ff4f37e1e6ad54ce1a5fd4e
+Size (postgresql-8.4.8.tar.bz2) = 14136376 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = a273a453e88e54467028c2a45e63bbbb304e227a
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb