Changes 8.2.14:

* Force WAL segment switch during pg_start_backup()
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
  security-definer functions
* Make "LOAD" of an already-loaded loadable module into a no-op
* Disallow empty passwords during LDAP authentication
* Fix handling of sub-SELECTs appearing in the arguments of an
  outer-level aggregate function
* Fix bugs associated with fetching a whole-row value from the output
  of a Sort or Materialize plan node
* Revert planner change that disabled partial-index and constraint
  exclusion optimizations when there were more than 100 clauses in an
  AND or OR list
* Fix hash calculation for data type interval
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'
* Fix overflow for INTERVAL 'x ms' when "x" is more than 2 million
  and integer datetimes are in use
* Fix calculation of distance between a point and a line segment
* Fix money data type to work in locales where currency amounts have
  no fractional digits, e.g. Japan
* Properly round datetime input like 00:12:57.9999999999999999999999999999
* Fix poor choice of page split point in GiST R-tree operator classes
* Avoid performance degradation in bulk inserts into GIN indexes when
  the input values are (nearly) in sorted order

4 files changed, 15 insertions, 10 deletions

diff --git a/databases/postgresql82-client/Makefile b/databases/postgresql82-client/Makefile
index e048b4a687e..54e0140aeeb 100644
--- a/databases/postgresql82-client/Makefile
+++ b/databases/postgresql82-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2009/06/14 22:57:59 joerg Exp $
+# $NetBSD: Makefile,v 1.10 2009/09/10 10:07:41 adam Exp $
 
 PKGNAME=	postgresql82-client-${BASE_VERS}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 PKG_DESTDIR_SUPPORT=	user-destdir
diff --git a/databases/postgresql82-client/PLIST b/databases/postgresql82-client/PLIST
index 47780c3bbb1..6534427f561 100644
--- a/databases/postgresql82-client/PLIST
+++ b/databases/postgresql82-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2009/06/14 22:57:59 joerg Exp $
+@comment $NetBSD: PLIST,v 1.16 2009/09/10 10:07:41 adam Exp $
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/af/LC_MESSAGES/libpq.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/initdb.mo
 ${PG_SUBPREFIX}${PKGLOCALEDIR}/locale/cs/LC_MESSAGES/libpq.mo
@@ -1201,6 +1201,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-22.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1223,6 +1224,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-19.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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
@@ -1241,6 +1243,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-14.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
@@ -1256,6 +1259,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-10.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-4.html
@@ -1529,7 +1533,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/wal-intro.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/wal-reliability.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/wal.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/warm-standby.html
-${PG_SUBPREFIX}share/doc/postgresql/html/x71214.html
+${PG_SUBPREFIX}share/doc/postgresql/html/x71219.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xaggr.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xfunc-c.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/xfunc-internal.html
diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index 71d452196a3..f7d223d190a 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2009/03/20 16:02:13 adam Exp $
+# $NetBSD: Makefile.common,v 1.17 2009/09/10 10:07:41 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -24,6 +24,8 @@ CONFLICTS+=	postgresql73-*
 CONFLICTS+=	postgresql74-*
 CONFLICTS+=	postgresql80-*
 CONFLICTS+=	postgresql81-*
+CONFLICTS+=	postgresql83-*
+CONFLICTS+=	postgresql84-*
 
 DISTINFO_FILE?=		${.CURDIR}/../postgresql82/distinfo
 COMMON_FILESDIR?=	${.CURDIR}/../postgresql82/files
@@ -36,7 +38,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql82/patches
 #
 # Note: Do not forget jdbc-postgresql82 when updating version
 #
-DIST_VERS?=		8.2.13
+DIST_VERS?=		8.2.14
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index 8f697b37054..f3816d61cc7 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.16 2009/03/20 16:02:13 adam Exp $
+$NetBSD: distinfo,v 1.17 2009/09/10 10:07:41 adam Exp $
 
-SHA1 (postgresql-8.2.13.tar.bz2) = 426467e0e45d67f553b1d066d9ea5e10fcbf8f72
-RMD160 (postgresql-8.2.13.tar.bz2) = 5344221ca42bbbc7f782d6ffd8c39cfe26f0c57b
-Size (postgresql-8.2.13.tar.bz2) = 12582719 bytes
+SHA1 (postgresql-8.2.14.tar.bz2) = b01d304cbae190b2d0c547d2a9c0c2f1cb1f8c98
+RMD160 (postgresql-8.2.14.tar.bz2) = 4ee0b40b0a00eef2f626ebb23fc5eb1bfcc7ae74
+Size (postgresql-8.2.14.tar.bz2) = 12638205 bytes
 SHA1 (patch-aa) = 850a02acbd718a01d3597a99e929e3b3f663f07c
 SHA1 (patch-ab) = d09e44921e9dd005e1b1dfbb5da4e56737ea05ab
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9