Security update to version 9.0.8.

Changes:

* Fix incorrect password transformation in contrib/pgcrypto's DES crypt()
function (Solar Designer)
* Ignore SECURITY DEFINER and SET attributes for a procedural language's call
handler (Tom Lane)
* Allow numeric timezone offsets in timestamp input to be up to 16 hours away
from UTC (Tom Lane)
* Fix timestamp conversion to cope when the given time is exactly the last DST
transition time for the current timezone (Tom Lane)
* Fix text to name and char to name casts to perform string truncation
correctly in multibyte encodings (Karl Schnaitter)
* Fix memory copying bug in to_tsquery() (Heikki Linnakangas)
* Ensure txid_current() reports the correct epoch when executed in hot standby
(Simon Riggs)
* Fix planner's handling of outer PlaceHolderVars within subqueries (Tom Lane)
* Fix slow session startup when pg_attribute is very large (Tom Lane)
* Ensure sequential scans check for query cancel reasonably often (Merlin
Moncure)
* Ensure the Windows implementation of PGSemaphoreLock() clears
ImmediateInterruptOK before returning (Tom Lane)
* Show whole-row variables safely when printing views or rules (Abbas Butt, Tom
Lane)
* Fix COPY FROM to properly handle null marker strings that correspond to
invalid encoding (Tom Lane)
* Ensure autovacuum worker processes perform stack depth checking properly
(Heikki Linnakangas)
* Fix logging collector to not lose log coherency under high load (Andrew
Dunstan)
* Fix logging collector to ensure it will restart file rotation after receiving
SIGHUP (Tom Lane)
* Fix WAL replay logic for GIN indexes to not fail if the index was
subsequently dropped (Tom Lane)
* Fix memory leak in PL/pgSQL's RETURN NEXT command (Joe Conway)
* Fix PL/pgSQL's GET DIAGNOSTICS command when the target is the function's
first variable (Tom Lane)
* Fix potential access off the end of memory in psql's expanded display (\x)
mode (Peter Eisentraut)
* Fix several performance problems in pg_dump when the database contains many
*bjects (Jeff Janes, Tom Lane)
* Fix pg_upgrade for the case that a database stored in a non-default
tablespace contains a table in the cluster's default tablespace (Bruce Momjian)
* In ecpg, fix rare memory leaks and possible overwrite of one byte after the
sqlca_t structure (Peter Eisentraut)
* Fix contrib/dblink's dblink_exec() to not leak temporary database connections
upon error (Tom Lane)
* Fix contrib/dblink to report the correct connection name in error messages
(Kyotaro Horiguchi)
* Fix contrib/vacuumlo to use multiple transactions when dropping many large
*bjects (Tim Lewis, Robert Haas, Tom Lane)
* Update time zone data files to tzdata release 2012c for DST law changes in
Antarctica, Armenia, Chile, Cuba, Falkland Islands, Gaza, Haiti, Hebron,
Morocco, Syria, and Tokelau Islands;

20 files changed, 28 insertions, 40 deletions

diff --git a/databases/postgresql90-adminpack/Makefile b/databases/postgresql90-adminpack/Makefile
index c0a2a1101bb..da3bc22b893 100644
--- a/databases/postgresql90-adminpack/Makefile
+++ b/databases/postgresql90-adminpack/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-adminpack-/}
-PKGREVISION=	1
 COMMENT=	Admin pack module for pgAdmin management
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-client/Makefile b/databases/postgresql90-client/Makefile
index 11c8aee5bf0..fdb993718d5 100644
--- a/databases/postgresql90-client/Makefile
+++ b/databases/postgresql90-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2012/06/14 07:45:34 sbd Exp $
+# $NetBSD: Makefile,v 1.13 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-client-/}
-PKGREVISION=	2
 COMMENT=	PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-datatypes/Makefile b/databases/postgresql90-datatypes/Makefile
index ecda4a233f3..41e6cfefd89 100644
--- a/databases/postgresql90-datatypes/Makefile
+++ b/databases/postgresql90-datatypes/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-datatypes-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL data types support modules
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-dblink/Makefile b/databases/postgresql90-dblink/Makefile
index 7981b9808a5..fdc4e0699f4 100644
--- a/databases/postgresql90-dblink/Makefile
+++ b/databases/postgresql90-dblink/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-dblink-/}
-PKGREVISION=	1
 COMMENT=	Dblink module for remote database connections
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-docs/Makefile b/databases/postgresql90-docs/Makefile
index 61be778425e..9108caecbd8 100644
--- a/databases/postgresql90-docs/Makefile
+++ b/databases/postgresql90-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.7 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-docs/PLIST b/databases/postgresql90-docs/PLIST
index 205132d7939..822dc484d49 100644
--- a/databases/postgresql90-docs/PLIST
+++ b/databases/postgresql90-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2012/03/03 14:01:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2012/07/01 19:42:06 morr Exp $
 ${PG_SUBPREFIX}man/man1/clusterdb.1
 ${PG_SUBPREFIX}man/man1/createdb.1
 ${PG_SUBPREFIX}man/man1/createlang.1
@@ -903,6 +903,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-18.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-4.html
@@ -915,6 +916,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-11.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-4.html
@@ -931,6 +933,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-9-0.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql90-fuzzystrmatch/Makefile b/databases/postgresql90-fuzzystrmatch/Makefile
index b7a66cc0ab9..55eeb1714d9 100644
--- a/databases/postgresql90-fuzzystrmatch/Makefile
+++ b/databases/postgresql90-fuzzystrmatch/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.5 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-fuzzystrmatch-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL fuzzystrmatch contribution
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-monitoring/Makefile b/databases/postgresql90-monitoring/Makefile
index b73b2db88e4..ff40d7830ae 100644
--- a/databases/postgresql90-monitoring/Makefile
+++ b/databases/postgresql90-monitoring/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.7 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-monitoring-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL monitoring tools
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-pgcrypto/Makefile b/databases/postgresql90-pgcrypto/Makefile
index 2b9daf3cd33..caab443c946 100644
--- a/databases/postgresql90-pgcrypto/Makefile
+++ b/databases/postgresql90-pgcrypto/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-pgcrypto-/}
-PKGREVISION=	1
 COMMENT=	Module providing cryptographic functions for PostgreSQL
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-plperl/Makefile b/databases/postgresql90-plperl/Makefile
index 80042e20b34..92c908f1d2c 100644
--- a/databases/postgresql90-plperl/Makefile
+++ b/databases/postgresql90-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.8 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-plpython/Makefile b/databases/postgresql90-plpython/Makefile
index 39e072ff87c..9f8a9180441 100644
--- a/databases/postgresql90-plpython/Makefile
+++ b/databases/postgresql90-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.7 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-plpython-/}
-PKGREVISION=	2
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-pltcl/Makefile b/databases/postgresql90-pltcl/Makefile
index 568d880884b..a13071d6ffb 100644
--- a/databases/postgresql90-pltcl/Makefile
+++ b/databases/postgresql90-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-replicationtools/Makefile b/databases/postgresql90-replicationtools/Makefile
index f38c5d6041c..ee13bdbf407 100644
--- a/databases/postgresql90-replicationtools/Makefile
+++ b/databases/postgresql90-replicationtools/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.4 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-replicationtools-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL replication tools
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 7dfdbca67d5..2964f46c588 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.11 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql90-server/PLIST b/databases/postgresql90-server/PLIST
index 7f575f5c062..d3f2121b051 100644
--- a/databases/postgresql90-server/PLIST
+++ b/databases/postgresql90-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2012/03/03 14:01:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2012/07/01 19:42:07 morr Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.so
@@ -166,6 +166,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Chihuahua
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Coral_Harbour
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Cordoba
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Costa_Rica
+${PG_SUBPREFIX}share/postgresql/timezone/America/Creston
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Cuiaba
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Curacao
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Danmarkshavn
diff --git a/databases/postgresql90-upgrade/Makefile b/databases/postgresql90-upgrade/Makefile
index 3a9bec66531..87b0fa0f17e 100644
--- a/databases/postgresql90-upgrade/Makefile
+++ b/databases/postgresql90-upgrade/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2012/06/14 07:45:35 sbd Exp $
+# $NetBSD: Makefile,v 1.6 2012/07/01 19:42:07 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-upgrade-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL binary upgrade tool
 MAINTAINER=	pkgsrc-users@NetBSD.org
 
diff --git a/databases/postgresql90-uuid/Makefile b/databases/postgresql90-uuid/Makefile
index e4043a02c91..0a13cb5d4e7 100644
--- a/databases/postgresql90-uuid/Makefile
+++ b/databases/postgresql90-uuid/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2011/04/22 14:40:41 obache Exp $
+# $NetBSD: Makefile,v 1.3 2012/07/01 19:42:07 morr Exp $
 #
 
 PGSQL_VERSION=	90
-PKGREVISION=	1
 
 .include "../../databases/postgresql-uuid/Makefile.common"
diff --git a/databases/postgresql90/Makefile b/databases/postgresql90/Makefile
index c32af94809c..a20a0118517 100644
--- a/databases/postgresql90/Makefile
+++ b/databases/postgresql90/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.4 2012/07/01 19:42:06 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql90-client>=${PKGVERSION_NOREV}:../../databases/postgresql90-client
diff --git a/databases/postgresql90/Makefile.common b/databases/postgresql90/Makefile.common
index 1068456becd..addaa8f0b7e 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2012/03/11 10:32:35 wiz Exp $
+# $NetBSD: Makefile.common,v 1.18 2012/07/01 19:42:06 morr Exp $
 #
 # used by databases/postgresql90-adminpack/Makefile
 # used by databases/postgresql90-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.0.7
+DISTNAME=	postgresql-9.0.8
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql90/distinfo b/databases/postgresql90/distinfo
index 3b4825229cd..6599bf8913b 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.10 2012/03/03 14:01:11 adam Exp $
+$NetBSD: distinfo,v 1.11 2012/07/01 19:42:06 morr Exp $
 
-SHA1 (postgresql-9.0.7.tar.bz2) = c0cf6de3cfa131b36107b3748ae44786ad638e12
-RMD160 (postgresql-9.0.7.tar.bz2) = 80a8c91233462515914aeb5c15cf63b7195da3ef
-Size (postgresql-9.0.7.tar.bz2) = 14977437 bytes
+SHA1 (postgresql-9.0.8.tar.bz2) = 240d2d45bc87d8cdad8e2b74cf378f5668b604fe
+RMD160 (postgresql-9.0.8.tar.bz2) = fab8564774c99300ca8a69298417eec960e70601
+Size (postgresql-9.0.8.tar.bz2) = 14998065 bytes
 SHA1 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5