Security update to version 8.4.12.

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 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)
* 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
objects (Jeff Janes, Tom Lane)
* 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)
* 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; also historical corrections for Canada.

14 files changed, 21 insertions, 28 deletions

diff --git a/databases/postgresql84-adminpack/Makefile b/databases/postgresql84-adminpack/Makefile
index 8b8ae9176af..7491e082d8b 100644
--- a/databases/postgresql84-adminpack/Makefile
+++ b/databases/postgresql84-adminpack/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:30:23 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-adminpack-/}
-PKGREVISION=	1
 COMMENT=	Admin pack module for pgAdmin management
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-client/Makefile b/databases/postgresql84-client/Makefile
index 9a71a903d04..ada580c385d 100644
--- a/databases/postgresql84-client/Makefile
+++ b/databases/postgresql84-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.18 2012/07/01 19:30:23 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index 244a0008953..40a9091149e 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2012/03/05 14:13:19 adam Exp $
+@comment $NetBSD: PLIST,v 1.14 2012/07/01 19:30:23 morr Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1333,6 +1333,7 @@ share/doc/postgresql/html/release-8-3-15.html
 share/doc/postgresql/html/release-8-3-16.html
 share/doc/postgresql/html/release-8-3-17.html
 share/doc/postgresql/html/release-8-3-18.html
+share/doc/postgresql/html/release-8-3-19.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
@@ -1345,6 +1346,7 @@ share/doc/postgresql/html/release-8-3.html
 share/doc/postgresql/html/release-8-4-1.html
 share/doc/postgresql/html/release-8-4-10.html
 share/doc/postgresql/html/release-8-4-11.html
+share/doc/postgresql/html/release-8-4-12.html
 share/doc/postgresql/html/release-8-4-2.html
 share/doc/postgresql/html/release-8-4-3.html
 share/doc/postgresql/html/release-8-4-4.html
diff --git a/databases/postgresql84-dblink/Makefile b/databases/postgresql84-dblink/Makefile
index f521a2393b5..7d3552907e1 100644
--- a/databases/postgresql84-dblink/Makefile
+++ b/databases/postgresql84-dblink/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.7 2012/07/01 19:30:23 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-dblink-/}
-PKGREVISION=	1
 COMMENT=	dblink module for remote database connections
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-pgcrypto/Makefile b/databases/postgresql84-pgcrypto/Makefile
index 4beffef0758..30cc7bb5a5d 100644
--- a/databases/postgresql84-pgcrypto/Makefile
+++ b/databases/postgresql84-pgcrypto/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.5 2012/07/01 19:30:23 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-pgcrypto-/}
-PKGREVISION=	1
 COMMENT=	Module providing cryptographic functions for PostgreSQL
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-plperl/Makefile b/databases/postgresql84-plperl/Makefile
index 4c91d7d03fb..0a97c5a129c 100644
--- a/databases/postgresql84-plperl/Makefile
+++ b/databases/postgresql84-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.11 2012/07/01 19:30:24 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-plpython/Makefile b/databases/postgresql84-plpython/Makefile
index c1d0ecc89ba..023eeda0fbe 100644
--- a/databases/postgresql84-plpython/Makefile
+++ b/databases/postgresql84-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.9 2012/07/01 19:30:24 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-plpython-/}
-PKGREVISION=	2
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-pltcl/Makefile b/databases/postgresql84-pltcl/Makefile
index cac538de7c5..75d424168ad 100644
--- a/databases/postgresql84-pltcl/Makefile
+++ b/databases/postgresql84-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.7 2012/07/01 19:30:24 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 7dce423ecab..372c210bfe4 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2012/06/14 07:45:36 sbd Exp $
+# $NetBSD: Makefile,v 1.14 2012/07/01 19:30:24 morr 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 6f96c1a93d3..f1454d58357 100644
--- a/databases/postgresql84-server/PLIST
+++ b/databases/postgresql84-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2011/12/15 17:16:13 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2012/07/01 19:30:24 morr Exp $
 bin/postgres
 bin/postmaster
 lib/postgresql/ascii_and_mic.so
@@ -161,6 +161,7 @@ share/postgresql/timezone/America/Chihuahua
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao
 share/postgresql/timezone/America/Danmarkshavn
diff --git a/databases/postgresql84-uuid/Makefile b/databases/postgresql84-uuid/Makefile
index a9785779716..ae7d04fa63b 100644
--- a/databases/postgresql84-uuid/Makefile
+++ b/databases/postgresql84-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:30:24 morr Exp $
 #
 
 PGSQL_VERSION=	84
-PKGREVISION=	1
 
 .include "../../databases/postgresql-uuid/Makefile.common"
diff --git a/databases/postgresql84/Makefile b/databases/postgresql84/Makefile
index 2545e620356..c836d2dbe90 100644
--- a/databases/postgresql84/Makefile
+++ b/databases/postgresql84/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2012/06/14 07:45:37 sbd Exp $
+# $NetBSD: Makefile,v 1.4 2012/07/01 19:30:23 morr Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql84-client>=${PKGVERSION_NOREV}:../../databases/postgresql84-client
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index 6f3f963b706..32f3eeafc60 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.19 2012/03/11 10:32:35 wiz Exp $
+# $NetBSD: Makefile.common,v 1.20 2012/07/01 19:30:23 morr Exp $
 #
 # used by databases/postgresql84-adminpack/Makefile
 # used by databases/postgresql84-client/Makefile
@@ -17,7 +17,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-8.4.11
+DISTNAME=	postgresql-8.4.12
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index f5140258c03..854d4521850 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.17 2012/03/05 14:13:19 adam Exp $
+$NetBSD: distinfo,v 1.18 2012/07/01 19:30:23 morr Exp $
 
-SHA1 (postgresql-8.4.11.tar.bz2) = ce9581b9f03bd884417b988ec317ce2ed06bb15f
-RMD160 (postgresql-8.4.11.tar.bz2) = 85b4be0884ca11855eb0dbc1541403e7baf7c0aa
-Size (postgresql-8.4.11.tar.bz2) = 14502434 bytes
+SHA1 (postgresql-8.4.12.tar.bz2) = 04ad9650573df7723511f57ef8cdeadce8d3855d
+RMD160 (postgresql-8.4.12.tar.bz2) = 2aa0da64dc3220497d510bd60a1abf0b68fd51ef
+Size (postgresql-8.4.12.tar.bz2) = 14509007 bytes
 SHA1 (patch-aa) = 72437773d67939c8d8c8e9a99caf430590fd726f
 SHA1 (patch-ab) = aa46d88c8a72edaf95880de48474ea484d6d2bf5
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb