Changes 8.4.2:

* Protect against indirect security threats caused by index functions
  changing session-local state
* Reject SSL certificates containing an embedded null byte in the
  common name (CN) field
* Fix hash index corruption
* Fix possible crash during backend-startup-time cache initialization
* Avoid crash on empty thesaurus dictionary
* Prevent signals from interrupting VACUUM at unsafe times
* Fix possible crash due to integer overflow in hash table size
  calculation
* Fix crash if a DROP is attempted on an internally-dependent object
* Fix very rare crash in inet/cidr comparisons
* Ensure that shared tuple-level locks held by prepared transactions
  are not ignored
* Fix premature drop of temporary files used for a cursor that is
  accessed within a subtransaction
* Fix memory leak in syslogger process when rotating to a new CSV
  logfile
* Fix memory leak in postmaster when re-parsing "pg_hba.conf"
* Fix Windows permission-downgrade logic
* Make FOR UPDATE/SHARE in the primary query not propagate into WITH
  queries
* Fix bug with a WITH RECURSIVE query immediately inside another one
* Fix concurrency bug in hash indexes
* Fix incorrect logic for GiST index page splits, when the split
  depends on a non-first column of the index
* Fix wrong search results for a multi-column GIN index with
  fastupdate enabled
* More...

6 files changed, 19 insertions, 15 deletions

diff --git a/databases/postgresql84-client/Makefile b/databases/postgresql84-client/Makefile
index 9b43679a087..a0035c27430 100644
--- a/databases/postgresql84-client/Makefile
+++ b/databases/postgresql84-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2009/12/15 22:39:40 fhajny Exp $
+# $NetBSD: Makefile,v 1.3 2009/12/16 13:30:54 adam Exp $
 
 PKGNAME=	postgresql84-client-${BASE_VERS}
-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 973f5dad2f0..4346db762ba 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2009/12/15 22:39:40 fhajny Exp $
+@comment $NetBSD: PLIST,v 1.4 2009/12/16 13:30:54 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -206,8 +206,8 @@ ${PG_SUBPREFIX}include/postgresql/server/executor/spi.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/spi_priv.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/tstoreReceiver.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/tuptable.h
-${PG_SUBPREFIX}include/postgresql/server/foreign/foreign.h
 ${PG_SUBPREFIX}include/postgresql/server/fmgr.h
+${PG_SUBPREFIX}include/postgresql/server/foreign/foreign.h
 ${PG_SUBPREFIX}include/postgresql/server/funcapi.h
 ${PG_SUBPREFIX}include/postgresql/server/getaddrinfo.h
 ${PG_SUBPREFIX}include/postgresql/server/getopt_long.h
@@ -791,9 +791,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/contrib-spi.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/contrib.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/creating-cluster.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/cube.html
-${PG_SUBPREFIX}share/doc/postgresql/html/cvs-tree.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/cvs.html
-${PG_SUBPREFIX}share/doc/postgresql/html/cvsup.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/database-roles.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/datatype-binary.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/datatype-bit.html
@@ -923,6 +921,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/gist-implementation.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/gist-intro.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/gist-recovery.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/gist.html
+${PG_SUBPREFIX}share/doc/postgresql/html/git.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/high-availability.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/history.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/hstore.html
@@ -1232,6 +1231,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-24.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-25.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-26.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-27.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-5.html
@@ -1255,6 +1255,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-21.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-22.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-23.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-5.html
@@ -1273,6 +1274,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-18.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1288,6 +1290,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
@@ -1305,8 +1308,10 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-7.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-8.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-9.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 912f1ea0fb6..fa875d7f703 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2009/12/15 21:33:49 joerg Exp $
+# $NetBSD: Makefile,v 1.3 2009/12/16 13:30:54 adam Exp $
 
 PKGNAME=	postgresql84-server-${BASE_VERS}
-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 934e865e855..6f3af02ed72 100644
--- a/databases/postgresql84-server/PLIST
+++ b/databases/postgresql84-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:20 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2009/12/16 13:30:54 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -326,6 +326,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Makassar
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Manila
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Muscat
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Nicosia
+${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novokuznetsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Novosibirsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Omsk
 ${PG_SUBPREFIX}share/postgresql/timezone/Asia/Oral
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index 4efeebf2c1b..dbb1950e147 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.2 2009/09/10 10:06:19 adam Exp $
+# $NetBSD: Makefile.common,v 1.3 2009/12/16 13:30:53 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -38,7 +38,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql84/patches
 #
 # Note: Do not forget jdbc-postgresql84 when updating version
 #
-DIST_VERS?=		8.4.1
+DIST_VERS?=		8.4.2
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql84-client+=	postgresql84-client>=${BASE_VERS}
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index d0dc564ce9b..5aa7000162d 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.2 2009/09/10 10:06:19 adam Exp $
+$NetBSD: distinfo,v 1.3 2009/12/16 13:30:53 adam Exp $
 
-SHA1 (postgresql-8.4.1.tar.bz2) = e6903f0029402ef8fb12645a177204499ea5b2b7
-RMD160 (postgresql-8.4.1.tar.bz2) = ad03c250afd71091294a2a3e67d96b661883db87
-Size (postgresql-8.4.1.tar.bz2) = 13579302 bytes
+SHA1 (postgresql-8.4.2.tar.bz2) = a617698ef3b41a74fe2c4af346172eb03e7f8a7f
+RMD160 (postgresql-8.4.2.tar.bz2) = 8d0030f185e9581bec6e2a0df903596579621bce
+Size (postgresql-8.4.2.tar.bz2) = 13600699 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 3cf9c7f0f812d2e41681281538c3f707cec232c3
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb