Changes 8.3.12:

* Use a separate interpreter for each calling SQL userid in PL/Perl and PL/Tcl
* Prevent possible crashes in pg_get_expr() by disallowing it from being called
  with an argument that is not one of the system catalog columns it's intended
  to be used with
* Treat exit code 128 (ERROR_WAIT_NO_CHILDREN) as non-fatal on Windows
* Fix incorrect usage of non-strict OR joinclauses in Append indexscans
* Fix possible duplicate scans of UNION ALL member relations
* Fix "cannot handle unplanned sub-select" error
* Fix failure to mark cached plans as transient
* Reduce PANIC to ERROR in some occasionally-reported btree failure cases, and
  provide additional detail in the resulting error messages
* Prevent show_session_authorization() from crashing within autovacuum
  processes
* Defend against functions returning setof record where not all the returned
  rows are actually of the same rowtype
* Fix possible failure when hashing a pass-by-reference function result.
* Improve merge join's handling of NULLs in the join columns
* Take care to fsync the contents of lockfiles (both "postmaster.pid" and the
  socket lockfile) while writing them
* Avoid recursion while assigning XIDs to heavily-nested subtransactions
* Avoid holding open old WAL segments in the walwriter process
* Fix log_line_prefix's %i escape, which could produce junk early in backend
  startup
* Fix possible data corruption in "ALTER TABLE ... SET TABLESPACE" when
  archiving is enabled
* Allow "CREATE DATABASE" and "ALTER DATABASE ... SET TABLESPACE" to be
  interrupted by query-cancel
* Fix "REASSIGN OWNED" to handle operator classes and families
* Fix possible core dump when comparing two empty tsquery values
* Fix LIKE's handling of patterns containing % followed by _

6 files changed, 19 insertions, 17 deletions

diff --git a/databases/postgresql83-client/Makefile b/databases/postgresql83-client/Makefile
index e2ecbe8982d..6202112cfc2 100644
--- a/databases/postgresql83-client/Makefile
+++ b/databases/postgresql83-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2010/05/30 11:51:19 joerg Exp $
+# $NetBSD: Makefile,v 1.17 2010/10/07 15:52:40 adam Exp $
 
 PKGNAME=	postgresql83-client-${BASE_VERS}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql83-client/PLIST b/databases/postgresql83-client/PLIST
index 2b71f1a52cc..54142b10342 100644
--- a/databases/postgresql83-client/PLIST
+++ b/databases/postgresql83-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2010/05/30 11:51:19 joerg Exp $
+@comment $NetBSD: PLIST,v 1.14 2010/10/07 15:52:40 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -670,7 +670,6 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/LEGALNOTICE.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/acronyms.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/admin.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/adminpack.html
-${PG_SUBPREFIX}share/doc/postgresql/html/anoncvs.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/app-clusterdb.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/app-createdb.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/app-createlang.html
@@ -783,9 +782,6 @@ ${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
@@ -913,6 +909,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
@@ -1215,6 +1212,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-27.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-28.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-29.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-30.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-6.html
@@ -1240,6 +1238,7 @@ ${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-24.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-25.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-26.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
@@ -1262,6 +1261,7 @@ ${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-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-21.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-22.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-5.html
@@ -1279,6 +1279,7 @@ ${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-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-17.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-18.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
@@ -1291,6 +1292,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-11.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-12.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
@@ -1308,7 +1310,6 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/routine-reindex.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/routine-vacuuming.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/row-estimation-examples.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/rowtypes.html
-${PG_SUBPREFIX}share/doc/postgresql/html/rsync.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/rule-system.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/rules-privileges.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/rules-status.html
@@ -1339,6 +1340,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/server-shutdown.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/server-start.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/source-format.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/source.html
+${PG_SUBPREFIX}share/doc/postgresql/html/sourcerepo.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/spi-examples.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/spi-interface-support.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/spi-interface.html
diff --git a/databases/postgresql83-plperl/Makefile b/databases/postgresql83-plperl/Makefile
index 4e8f4367275..5a0749fcf54 100644
--- a/databases/postgresql83-plperl/Makefile
+++ b/databases/postgresql83-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2010/08/21 16:33:08 seb Exp $
+# $NetBSD: Makefile,v 1.8 2010/10/07 15:52:40 adam Exp $
 
 PKGNAME=	postgresql83-plperl-${BASE_VERS}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql83-server/PLIST b/databases/postgresql83-server/PLIST
index c5e4ebd785b..2679c794246 100644
--- a/databases/postgresql83-server/PLIST
+++ b/databases/postgresql83-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2010/05/20 12:36:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2010/10/07 15:52:40 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -573,6 +573,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/PST8PDT
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Apia
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Auckland
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chatham
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chuuk
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Easter
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Efate
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Enderbury
@@ -598,6 +599,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Noumea
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pago_Pago
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Palau
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pitcairn
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pohnpei
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Ponape
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Port_Moresby
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Rarotonga
diff --git a/databases/postgresql83/Makefile.common b/databases/postgresql83/Makefile.common
index a556d32da56..d24ae4d809d 100644
--- a/databases/postgresql83/Makefile.common
+++ b/databases/postgresql83/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.12 2010/05/20 12:36:28 adam Exp $
+# $NetBSD: Makefile.common,v 1.13 2010/10/07 15:52:40 adam Exp $
 #
 # used by databases/postgresql83-adminpack/Makefile
 # used by databases/postgresql83-client/Makefile
@@ -42,7 +42,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql83/patches
 # DIST_VERS		version number on the postgresql distfile
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 # Note: Do not forget jdbc-postgresql83 when updating version
-DIST_VERS?=		8.3.11
+DIST_VERS?=		8.3.12
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql83-client+=	postgresql83-client>=${BASE_VERS}
diff --git a/databases/postgresql83/distinfo b/databases/postgresql83/distinfo
index 6ab9af451fb..8afbfaffb7e 100644
--- a/databases/postgresql83/distinfo
+++ b/databases/postgresql83/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.12 2010/05/20 12:36:28 adam Exp $
+$NetBSD: distinfo,v 1.13 2010/10/07 15:52:40 adam Exp $
 
-SHA1 (postgresql-8.3.11.tar.bz2) = de3d768c66e832336465672de6f33924441bf3f2
-RMD160 (postgresql-8.3.11.tar.bz2) = 606f64235b2d48df0a26b46863fc76f94b32abbb
-Size (postgresql-8.3.11.tar.bz2) = 14217781 bytes
+SHA1 (postgresql-8.3.12.tar.bz2) = 1c78ba53f4a37c8f9d12a4abe37ac47e0049f46a
+RMD160 (postgresql-8.3.12.tar.bz2) = 00fd0e09b2c300069e616d7f7a116b93b8c2e402
+Size (postgresql-8.3.12.tar.bz2) = 14273431 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 7bf5635b0b93c3c0d33acd4e122e102c92ce7b76
 SHA1 (patch-ac) = 8e3a7021fdd01810d4ebcbd20002b28164b22279