Changes

Guarantee transmission of all WAL files before replica failover
Prevent downcasing of non-ASCII identifiers
Fix several minor memory leaks
Correct overcommit behavior when using more than 24GB of work memory
Improve planner cost estimates for choosing generic plans
Fix estimates of NULL rows in boolean columns
Make UNION ALL and inheritance query plans recheck parameterized paths
Correct pg_dump bugs for foreign tables, views, and extensions
Prevent a parallel pg_restore failure on certain indexes
Make REINDEX revalidate constraints
Prevent two deadlock issues in SP-GIST and REINDEX CONCURRENTLY
Prevent GiST index lookup crash
Fix several regular expression failures
Allow ALTER DEFAULT PRIVILEGES to work on all schemas
Loosen restrictions on keywords
Allow various spellings of infinity
Expand ability to compare rows to records and arrays
Prevent psql client crash on bad PSQLRC file
Add spinlock support for ARM64

21 files changed, 39 insertions, 45 deletions

diff --git a/databases/postgresql84-client/Makefile b/databases/postgresql84-client/Makefile
index fbd4dac2008..4cb4652f445 100644
--- a/databases/postgresql84-client/Makefile
+++ b/databases/postgresql84-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2013/07/15 02:02:19 ryoon Exp $
+# $NetBSD: Makefile,v 1.25 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql84/Makefile.common"
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index d24e1f8210b..477aa01daa5 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.19 2013/04/04 21:08:32 adam Exp $
+@comment $NetBSD: PLIST,v 1.20 2013/10/12 20:39:42 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -1356,6 +1356,7 @@ share/doc/postgresql/html/release-8-4-14.html
 share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-16.html
 share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.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-plperl/Makefile b/databases/postgresql84-plperl/Makefile
index 6d86d907d03..f9655fb41bd 100644
--- a/databases/postgresql84-plperl/Makefile
+++ b/databases/postgresql84-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2013/05/31 12:39:55 wiz Exp $
+# $NetBSD: Makefile,v 1.20 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql84-server>=${PKGVERSION_NOREV}:../../databases/postgresql84-server
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index c2c80003e71..300a368b150 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.21 2013/07/12 10:44:54 jperkin Exp $
+# $NetBSD: Makefile,v 1.22 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/84-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql84/Makefile b/databases/postgresql84/Makefile
index 3ea253f31c7..686bbb77ce3 100644
--- a/databases/postgresql84/Makefile
+++ b/databases/postgresql84/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2013/05/31 12:39:55 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2013/10/12 20:39:42 adam 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 602f6c310f5..d5cfb003c45 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.26 2013/04/04 21:08:32 adam Exp $
+# $NetBSD: Makefile.common,v 1.27 2013/10/12 20:39:42 adam 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.17
+DISTNAME=	postgresql-8.4.18
 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 61d51966697..39ead2b0f35 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.25 2013/04/04 21:08:32 adam Exp $
+$NetBSD: distinfo,v 1.26 2013/10/12 20:39:42 adam Exp $
 
-SHA1 (postgresql-8.4.17.tar.bz2) = 1c8760ad7048f6e62ac8c822fee653117f5beb57
-RMD160 (postgresql-8.4.17.tar.bz2) = 122acee594551be5e42f208dfde522a0ad1ce17d
-Size (postgresql-8.4.17.tar.bz2) = 14795028 bytes
+SHA1 (postgresql-8.4.18.tar.bz2) = e3ae82eb864af03ebf213c430c65e69fef472fbd
+RMD160 (postgresql-8.4.18.tar.bz2) = b0e37aa00e4c83af13369456afe5cd124692dc42
+Size (postgresql-8.4.18.tar.bz2) = 14819294 bytes
 SHA1 (patch-aa) = 72437773d67939c8d8c8e9a99caf430590fd726f
 SHA1 (patch-ab) = aa46d88c8a72edaf95880de48474ea484d6d2bf5
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb
diff --git a/databases/postgresql90-docs/Makefile b/databases/postgresql90-docs/Makefile
index 8c84674571f..71f623c9d7c 100644
--- a/databases/postgresql90-docs/Makefile
+++ b/databases/postgresql90-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2013/05/31 12:39:56 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql90/Makefile.common"
diff --git a/databases/postgresql90-docs/PLIST b/databases/postgresql90-docs/PLIST
index 4ae7c39edde..5906907789a 100644
--- a/databases/postgresql90-docs/PLIST
+++ b/databases/postgresql90-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2013/04/04 21:08:34 adam Exp $
+@comment $NetBSD: PLIST,v 1.16 2013/10/12 20:39:42 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -926,6 +926,7 @@ share/doc/postgresql/html/release-8-4-14.html
 share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-16.html
 share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.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
@@ -940,6 +941,7 @@ share/doc/postgresql/html/release-9-0-10.html
 share/doc/postgresql/html/release-9-0-11.html
 share/doc/postgresql/html/release-9-0-12.html
 share/doc/postgresql/html/release-9-0-13.html
+share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-2.html
 share/doc/postgresql/html/release-9-0-3.html
 share/doc/postgresql/html/release-9-0-4.html
diff --git a/databases/postgresql90-plperl/Makefile b/databases/postgresql90-plperl/Makefile
index 56999542eca..38ad3dd9d1a 100644
--- a/databases/postgresql90-plperl/Makefile
+++ b/databases/postgresql90-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.15 2013/05/31 12:39:56 wiz Exp $
+# $NetBSD: Makefile,v 1.16 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql90-server>=${PKGVERSION_NOREV}:../../databases/postgresql90-server
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 03fdecc6162..d57641584e0 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2013/07/12 10:44:54 jperkin Exp $
+# $NetBSD: Makefile,v 1.17 2013/10/12 20:39:42 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/90-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql90/Makefile b/databases/postgresql90/Makefile
index 00464e75ab3..05fe716f1d6 100644
--- a/databases/postgresql90/Makefile
+++ b/databases/postgresql90/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2013/05/31 12:39:55 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2013/10/12 20:39:42 adam 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 48b1c54e325..412918b52e2 100644
--- a/databases/postgresql90/Makefile.common
+++ b/databases/postgresql90/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.24 2013/04/04 21:08:33 adam Exp $
+# $NetBSD: Makefile.common,v 1.25 2013/10/12 20:39:42 adam 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.13
+DISTNAME=	postgresql-9.0.14
 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 8d0a40234fb..14a63e8132d 100644
--- a/databases/postgresql90/distinfo
+++ b/databases/postgresql90/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.17 2013/04/04 21:08:33 adam Exp $
+$NetBSD: distinfo,v 1.18 2013/10/12 20:39:42 adam Exp $
 
-SHA1 (postgresql-9.0.13.tar.bz2) = d4812cba43c1a76b66f43687df78c86996a23620
-RMD160 (postgresql-9.0.13.tar.bz2) = 1b7e37cb4ecb1e512f5ca3c0350c9e908d03a01d
-Size (postgresql-9.0.13.tar.bz2) = 15139873 bytes
+SHA1 (postgresql-9.0.14.tar.bz2) = f6d59d6fddbecc16d8f4d3ccbb70d62f77d56564
+RMD160 (postgresql-9.0.14.tar.bz2) = 17e5f49bb8497a92f641b2bc607cbd5aa6848104
+Size (postgresql-9.0.14.tar.bz2) = 15154015 bytes
 SHA1 (patch-aa) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-ab) = 6adfc53e325abe69582f1c7971f56144c697e9c1
 SHA1 (patch-ac) = 76ddd3015d93b19cdd6000eaffc4f53cbd4965b5
diff --git a/databases/postgresql91-docs/Makefile b/databases/postgresql91-docs/Makefile
index cf4203f6b4b..c60330a0c66 100644
--- a/databases/postgresql91-docs/Makefile
+++ b/databases/postgresql91-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2013/05/31 12:39:56 wiz Exp $
+# $NetBSD: Makefile,v 1.8 2013/10/12 20:39:43 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/91-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql91/Makefile.common"
diff --git a/databases/postgresql91-docs/PLIST b/databases/postgresql91-docs/PLIST
index d2d5a4bf984..448d1b94310 100644
--- a/databases/postgresql91-docs/PLIST
+++ b/databases/postgresql91-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2013/04/04 21:08:35 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2013/10/12 20:39:43 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -972,6 +972,7 @@ share/doc/postgresql/html/release-8-4-14.html
 share/doc/postgresql/html/release-8-4-15.html
 share/doc/postgresql/html/release-8-4-16.html
 share/doc/postgresql/html/release-8-4-17.html
+share/doc/postgresql/html/release-8-4-18.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
@@ -986,6 +987,7 @@ share/doc/postgresql/html/release-9-0-10.html
 share/doc/postgresql/html/release-9-0-11.html
 share/doc/postgresql/html/release-9-0-12.html
 share/doc/postgresql/html/release-9-0-13.html
+share/doc/postgresql/html/release-9-0-14.html
 share/doc/postgresql/html/release-9-0-2.html
 share/doc/postgresql/html/release-9-0-3.html
 share/doc/postgresql/html/release-9-0-4.html
@@ -996,6 +998,7 @@ share/doc/postgresql/html/release-9-0-8.html
 share/doc/postgresql/html/release-9-0-9.html
 share/doc/postgresql/html/release-9-0.html
 share/doc/postgresql/html/release-9-1-1.html
+share/doc/postgresql/html/release-9-1-10.html
 share/doc/postgresql/html/release-9-1-2.html
 share/doc/postgresql/html/release-9-1-3.html
 share/doc/postgresql/html/release-9-1-4.html
diff --git a/databases/postgresql91-plperl/Makefile b/databases/postgresql91-plperl/Makefile
index e966d579193..79f717cbf1c 100644
--- a/databases/postgresql91-plperl/Makefile
+++ b/databases/postgresql91-plperl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2013/05/31 12:39:56 wiz Exp $
+# $NetBSD: Makefile,v 1.11 2013/10/12 20:39:43 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/91-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index fa76a9eb701..a7420732f93 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2013/07/12 10:44:54 jperkin Exp $
+# $NetBSD: Makefile,v 1.9 2013/10/12 20:39:43 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/91-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql91/Makefile b/databases/postgresql91/Makefile
index 433abcde085..465621d6e6b 100644
--- a/databases/postgresql91/Makefile
+++ b/databases/postgresql91/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2013/05/31 12:39:56 wiz Exp $
+# $NetBSD: Makefile,v 1.5 2013/10/12 20:39:43 adam Exp $
 
 PKGNAME=	${DISTNAME:C/-/91-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql91-client>=${PKGVERSION_NOREV}:../../databases/postgresql91-client
diff --git a/databases/postgresql91/Makefile.common b/databases/postgresql91/Makefile.common
index be716d2bd9f..841fb082c23 100644
--- a/databases/postgresql91/Makefile.common
+++ b/databases/postgresql91/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.14 2013/04/04 21:08:35 adam Exp $
+# $NetBSD: Makefile.common,v 1.15 2013/10/12 20:39:43 adam Exp $
 #
 # used by databases/postgresql91-adminpack/Makefile
 # used by databases/postgresql91-client/Makefile
@@ -21,7 +21,7 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=	postgresql-9.1.9
+DISTNAME=	postgresql-9.1.10
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql91/distinfo b/databases/postgresql91/distinfo
index 794a82e2b22..d5e7c31c484 100644
--- a/databases/postgresql91/distinfo
+++ b/databases/postgresql91/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.14 2013/04/04 21:08:35 adam Exp $
+$NetBSD: distinfo,v 1.15 2013/10/12 20:39:43 adam Exp $
 
-SHA1 (postgresql-9.1.9.tar.bz2) = 4cbbfc5be9b8e6fe3d67c5075c212bcb057eac20
-RMD160 (postgresql-9.1.9.tar.bz2) = 65aa38a4f687cd278bedcf4f1516089ab65924d1
-Size (postgresql-9.1.9.tar.bz2) = 15815421 bytes
+SHA1 (postgresql-9.1.10.tar.bz2) = ac2882d50f5a4798d1fcc7c6445c4964b1edda5f
+RMD160 (postgresql-9.1.10.tar.bz2) = 9ffafab4c2b60be33789066b1d5563f370685500
+Size (postgresql-9.1.10.tar.bz2) = 15849107 bytes
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7
 SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04