Changes 8.0.9:

* Fix crash when referencing NEW row values in rule WHERE expressions
  (Tom)
* Fix core dump when an untyped literal is taken as ANYARRAY
* Fix mishandling of AFTER triggers when query contains a SQL
  function returning multiple rows (Tom)
* Fix "ALTER TABLE ... TYPE" to recheck NOT NULL for USING clause
  (Tom)
* Fix string_to_array() to handle overlapping matches for the
  separator string
  For example, string_to_array('123xx456xxx789', 'xx').
* Fix corner cases in pattern matching for psql's \d commands
* Fix index-corrupting bugs in /contrib/ltree (Teodor)
* Numerous robustness fixes in ecpg (Joachim Wieland)
* Fix backslash escaping in /contrib/dbmirror
* Fix instability of statistics collection on Win32 (Tom, Andrew)
* Fixes for AIX and Intel compilers (Tom)

6 files changed, 38 insertions, 35 deletions

diff --git a/databases/postgresql80-client/Makefile b/databases/postgresql80-client/Makefile
index 7ffd0e1f346..dc2226cab08 100644
--- a/databases/postgresql80-client/Makefile
+++ b/databases/postgresql80-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.16 2006/02/21 19:05:07 joerg Exp $
+# $NetBSD: Makefile,v 1.17 2006/10/18 18:39:09 adam Exp $
 
 PKGNAME=	postgresql80-client-${BASE_VERS}
 COMMENT=	PostgreSQL database client programs
@@ -65,13 +65,13 @@ USE_GNU_READLINE=	yes
 #
 .if ${OPSYS} == "SunOS"
 post-wrapper:
-	${TOUCH} ${BUILDLINK_DIR}/include/crypt.h
+	touch ${BUILDLINK_DIR}/include/crypt.h
 .endif
 
 pre-build:
 	${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}			\
 	cd ${WRKSRC}/src/backend &&					\
-	${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}	\
+	env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}	\
 		../../src/include/parser/parse.h			\
 		../../src/include/utils/fmgroids.h
 
@@ -82,7 +82,7 @@ post-install:
 	do								\
 		${INSTALL_DATA} $$file ${PG_DOC_DIR}/$$file;		\
         done
-	${CP} -R ${WRKSRC}/doc/TODO.detail ${PG_DOC_DIR}
-	${CHOWN} -R ${DOCOWN}:${DOCGRP} ${PG_DOC_DIR}/TODO.detail
+	cp -R ${WRKSRC}/doc/TODO.detail ${PG_DOC_DIR}
+	chown -R ${DOCOWN}:${DOCGRP} ${PG_DOC_DIR}/TODO.detail
 
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80-client/PLIST b/databases/postgresql80-client/PLIST
index 127c4645bf5..f4e43741904 100644
--- a/databases/postgresql80-client/PLIST
+++ b/databases/postgresql80-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2006/05/26 17:47:58 joerg Exp $
+@comment $NetBSD: PLIST,v 1.12 2006/10/18 18:39:09 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -947,6 +947,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-12.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-4.html
@@ -961,6 +962,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-10.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -977,6 +979,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
 ${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.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index 5f04b56a27c..ad44d4c4532 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.21 2006/04/23 00:12:37 jlam Exp $
+# $NetBSD: Makefile,v 1.22 2006/10/18 18:39:19 adam Exp $
 
 PKGNAME=	postgresql80-server-${BASE_VERS}
 COMMENT=	PostgreSQL database server programs
@@ -75,17 +75,17 @@ RCD_SCRIPTS=		pgsql
 #
 post-wrapper:
 .if ${OPSYS} == "SunOS"
-	${TOUCH} ${BUILDLINK_DIR}/include/crypt.h
+	touch ${BUILDLINK_DIR}/include/crypt.h
 .endif
 
 pre-build:
 	${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}			\
 	cd ${WRKSRC}/src/backend &&					\
-	${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}	\
+	env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}	\
 		../../src/include/parser/parse.h			\
 		../../src/include/utils/fmgroids.h
 	${_PKG_SILENT}${_PKG_DEBUG}${_ULIMIT_CMD}			\
 	cd ${WRKSRC}/src/port &&					\
-       	${SETENV} ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}
+       	env ${MAKE_ENV} ${MAKE_PROGRAM} ${BUILD_MAKE_FLAGS}
 
 .include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql80/Makefile.common b/databases/postgresql80/Makefile.common
index 68050a1cb09..c5561c0341c 100644
--- a/databases/postgresql80/Makefile.common
+++ b/databases/postgresql80/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.23 2006/05/26 17:47:58 joerg Exp $
+# $NetBSD: Makefile.common,v 1.24 2006/10/18 18:38:57 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -11,7 +11,7 @@
 
 DISTNAME?=	postgresql-${DIST_VERS}
 CATEGORIES+=	databases
-MASTER_SITES?=  ${MASTER_SITE_PGSQL:=source/v${DIST_VERS}/}
+MASTER_SITES?=	${MASTER_SITE_PGSQL:=source/v${DIST_VERS}/}
 EXTRACT_SUFX=	.tar.bz2
 
 MAINTAINER?=	joerg@NetBSD.org
@@ -35,7 +35,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql80/patches
 #
 # Note: Do not forget jdbc-postgresql80 when updating version
 #
-DIST_VERS?=		8.0.8
+DIST_VERS?=		8.0.9
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql80-client+=	postgresql80-client>=${BASE_VERS}
@@ -114,48 +114,48 @@ LIBS+=		-lintl
 
 post-extract:
 	if ${TEST} -d ${WRKSRC}/src; then				\
-		${RM} -f ${WRKSRC}/src/Makefile.custom;			\
-		${CP} -f ${COMMON_FILESDIR}/Makefile.custom		\
+		rm -f ${WRKSRC}/src/Makefile.custom;			\
+		cp -f ${COMMON_FILESDIR}/Makefile.custom		\
 			${WRKSRC}/src/Makefile.custom;			\
-		${RM} -f ${WRKSRC}/src/Makefile.shlib;			\
-		${CP} -f ${COMMON_FILESDIR}/Makefile.libtool		\
+		rm -f ${WRKSRC}/src/Makefile.shlib;			\
+		cp -f ${COMMON_FILESDIR}/Makefile.libtool		\
 			${WRKSRC}/src/Makefile.shlib;			\
 	fi
 	if ${TEST} -d ${WRKSRC}/src/interfaces/libpq; then		\
-		${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
-		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq		\
+		rm -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
+		cp -f ${COMMON_FILESDIR}/GNUmakefile.libpq		\
 			${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
 	fi
 	if ${TEST} -d ${WRKSRC}/src/interfaces/libpgtcl; then		\
-		${RM} -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
-		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl	\
+		rm -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
+		cp -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl	\
 			${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
 	fi
 .if !empty(USE_LIBLTDL:M[yY][eE][sS])
 	if ${TEST} -d ${WRKSRC}/src/backend/port/dynloader; then	\
 		template=${PGSQL_TEMPLATE.${OPSYS}:Q};			\
-		${RM} -f ${WRKSRC}/src/backend/port/dynloader/$$template.[ch]; \
-		${CP} -f ${COMMON_FILESDIR}/dynloader-ltdl.h		\
+		rm -f ${WRKSRC}/src/backend/port/dynloader/$$template.[ch]; \
+		cp -f ${COMMON_FILESDIR}/dynloader-ltdl.h		\
 			${WRKSRC}/src/backend/port/dynloader/$$template.h; \
 		${ECHO} "static int dummy = 0;"				\
 			 >${WRKSRC}/src/backend/port/dynloader/$$template.c
 	fi
 .endif
 	if ${TEST} -d ${WRKSRC}/src/template; then			\
-		${TOUCH} ${WRKSRC}/src/template/dragonfly;		\
+		touch ${WRKSRC}/src/template/dragonfly;		\
 	fi
 	if ${TEST} -d ${WRKSRC}/src/backend/port/dynloader; then	\
-		${CP} ${WRKSRC}/src/backend/port/dynloader/freebsd.c	\
+		cp ${WRKSRC}/src/backend/port/dynloader/freebsd.c	\
 			${WRKSRC}/src/backend/port/dynloader/dragonfly.c; \
-		${CP} ${WRKSRC}/src/backend/port/dynloader/freebsd.h	\
+		cp ${WRKSRC}/src/backend/port/dynloader/freebsd.h	\
 			${WRKSRC}/src/backend/port/dynloader/dragonfly.h; \
 	fi
 	if ${TEST} -d ${WRKSRC}/src/include/port; then			\
-		${CP} ${WRKSRC}/src/include/port/freebsd.h		\
+		cp ${WRKSRC}/src/include/port/freebsd.h		\
 			${WRKSRC}/src/include/port/dragonfly.h;		\
 	fi
 	if ${TEST} -d ${WRKSRC}/src/makefiles; then			\
-		${CP} ${WRKSRC}/src/makefiles/Makefile.freebsd		\
+		cp ${WRKSRC}/src/makefiles/Makefile.freebsd		\
 			${WRKSRC}/src/makefiles/Makefile.dragonfly;	\
 	fi
 
@@ -165,7 +165,7 @@ post-extract:
 # PostgreSQL sources).  Please don't change this value unless you know
 # what you are doing.
 #
-BUILD_DEFS+=    PGSQL_BLCKSZ
+BUILD_DEFS+=	PGSQL_BLCKSZ
 
 .if defined(PGSQL_BLCKSZ)
 .PHONY: pgsql-blcksz
diff --git a/databases/postgresql80/distinfo b/databases/postgresql80/distinfo
index 1c1cfff5666..e5fa2ba06de 100644
--- a/databases/postgresql80/distinfo
+++ b/databases/postgresql80/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.13 2006/05/26 17:47:58 joerg Exp $
+$NetBSD: distinfo,v 1.14 2006/10/18 18:38:57 adam Exp $
 
-SHA1 (postgresql-8.0.8.tar.bz2) = abc9a418fbdb1e101f94912099679206ef6580d1
-RMD160 (postgresql-8.0.8.tar.bz2) = 3769689e62995239ea54e25f1fe6dbe83a6fcced
-Size (postgresql-8.0.8.tar.bz2) = 11165942 bytes
+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 (patch-aa) = d681a5b2bb4dfce4e3db1490b97fed1b99ff445f
 SHA1 (patch-ab) = 1a80710d13723f2c8130d8235bb40c43af9d9ccd
 SHA1 (patch-ac) = 092d96fe2baafe8eef731b45a85d33fc40584044
diff --git a/databases/postgresql80/options.mk b/databases/postgresql80/options.mk
index 498b2a404a9..b37bb78cc0d 100644
--- a/databases/postgresql80/options.mk
+++ b/databases/postgresql80/options.mk
@@ -1,4 +1,4 @@
-# $NetBSD: options.mk,v 1.3 2005/10/23 20:16:52 jlam Exp $
+# $NetBSD: options.mk,v 1.4 2006/10/18 18:38:57 adam Exp $
 
 PKG_SUPPORTED_OPTIONS+=		pgsql-hier-query
 
@@ -9,7 +9,7 @@ PKG_SUPPORTED_OPTIONS+=		pgsql-hier-query
 ###
 .if !empty(PKG_OPTIONS:Mpam)
 .  include "../../mk/pam.buildlink3.mk"
-CONFIGURE_ARGS+=        --with-pam
+CONFIGURE_ARGS+=	--with-pam
 .endif
 
 ###