Changes 8.3.15:

* 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

6 files changed, 20 insertions, 19 deletions

diff --git a/databases/postgresql83-client/Makefile b/databases/postgresql83-client/Makefile
index ea403620dd5..36f50a4db9c 100644
--- a/databases/postgresql83-client/Makefile
+++ b/databases/postgresql83-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2011/04/22 13:42:06 obache Exp $
+# $NetBSD: Makefile,v 1.23 2011/04/22 13:50:38 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/83-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
@@ -87,11 +86,9 @@ pre-build:
 		../../src/include/utils/fmgroids.h
 
 post-install:
-	set -e; cd ${WRKSRC}/doc; for file in FAQ*; do \
-		${INSTALL_DATA} $$file ${DESTDIR}${PREFIX}/share/doc/postgresql/$$file;	\
-	done
-	set -e; for file in ${PGXS_FILES}; do				\
-		${INSTALL_DATA} ${WRKSRC}/$$file ${DEST_PGXS}/$$file;	\
-	done
+	${INSTALL_DATA} ${WRKSRC}/doc/FAQ* ${DESTDIR}${PREFIX}/share/doc/postgresql/
+.for file in ${PGXS_FILES}
+	${INSTALL_DATA} ${WRKSRC}/${file} ${DEST_PGXS}/${file}
+.endfor
 
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql83-client/PLIST b/databases/postgresql83-client/PLIST
index 357975e3e59..1c9a229fa31 100644
--- a/databases/postgresql83-client/PLIST
+++ b/databases/postgresql83-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.16 2011/02/15 09:06:32 adam Exp $
+@comment $NetBSD: PLIST,v 1.17 2011/04/22 13:50:38 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1281,6 +1281,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
@@ -1295,6 +1296,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
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index fe03be0deb5..4379c474c10 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2011/04/22 13:43:14 obache Exp $
+# $NetBSD: Makefile,v 1.17 2011/04/22 13:50:39 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/83-server-/}
-PKGREVISION=	2
 COMMENT=	PostgreSQL database server programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql83-server/PLIST b/databases/postgresql83-server/PLIST
index 510a6882590..28aa5a1a170 100644
--- a/databases/postgresql83-server/PLIST
+++ b/databases/postgresql83-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2011/02/15 09:06:33 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2011/04/22 13:50:39 adam Exp $
 bin/postgres
 bin/postmaster
 lib/postgresql/ascii_and_mic.so
@@ -217,6 +217,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
@@ -229,6 +230,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
@@ -255,6 +257,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/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index d5a0d7c6400..4ce49b81f85 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2011/02/15 09:06:31 adam Exp $
+# $NetBSD: Makefile.common,v 1.18 2011/04/22 13:50:38 adam Exp $
 #
 # used by databases/postgresql83-adminpack/Makefile
 # used by databases/postgresql83-client/Makefile
@@ -17,13 +17,14 @@
 
 .include "../../databases/postgresql83/Makefile.mirrors"
 
-DISTNAME=	postgresql-8.3.14
+DISTNAME=	postgresql-8.3.15
 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/postgresql83/distinfo b/databases/postgresql83/distinfo
index 95efe3fd480..bbb2611d976 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.15 2011/02/15 09:06:32 adam Exp $
+$NetBSD: distinfo,v 1.16 2011/04/22 13:50:38 adam Exp $
 
-SHA1 (postgresql-8.3.14.tar.bz2) = aec29d9be73e90b88b2d1d5eadff8fffc5681e59
-RMD160 (postgresql-8.3.14.tar.bz2) = 353996ca82141186f67d59a8ae37b91586413807
-Size (postgresql-8.3.14.tar.bz2) = 14345092 bytes
+SHA1 (postgresql-8.3.15.tar.bz2) = b20895aa66c15d5f394579aed50ce88c4018ecc0
+RMD160 (postgresql-8.3.15.tar.bz2) = 66c5f79083231f5afb7cb3b41637fc8eb7ae5225
+Size (postgresql-8.3.15.tar.bz2) = 14344586 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279
@@ -11,4 +11,3 @@ SHA1 (patch-af) = fcb43276c1f3349f62acfc37ac0bd6ccaae96f29
 SHA1 (patch-ag) = 402d5d211af99efdfa35677299c97e91e14ed85d
 SHA1 (patch-ah) = 3640573195f66a46c37d9fca2648d6be39f5593b
 SHA1 (patch-ai) = a2364b8e1e8a3094e1c5bfb0cad2d0babe0a8841
-SHA1 (patch-aj) = c389f9b8f39ddb61e58b5fe87ffabb789c71d4e0