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)

3 files changed, 25 insertions, 25 deletions

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
 
 ###