Changes 8.2.3:

* Remove overly-restrictive check for type length in constraints and
  functional indexes
* Fix optimization so MIN/MAX in subqueries can again use indexes

3 files changed, 11 insertions, 8 deletions

diff --git a/databases/postgresql82-client/PLIST b/databases/postgresql82-client/PLIST
index 69d642bd6e7..d04acfc1ac8 100644
--- a/databases/postgresql82-client/PLIST
+++ b/databases/postgresql82-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2007/02/05 11:10:02 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2007/02/08 20:00:27 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
@@ -1198,6 +1198,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-11.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-12.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
@@ -1214,10 +1215,12 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-1.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.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/role-attributes.html
@@ -1483,7 +1486,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/x71114.html
+${PG_SUBPREFIX}share/doc/postgresql/html/x71115.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 0c1bc383e08..3c48719d71c 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.3 2007/02/05 11:10:02 adam Exp $
+# $NetBSD: Makefile.common,v 1.4 2007/02/08 20:00:27 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -36,7 +36,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql82/patches
 #
 # Note: Do not forget jdbc-postgresql82 when updating version
 #
-DIST_VERS?=		8.2.2
+DIST_VERS?=		8.2.3
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index d041f6faea3..4a3e7307e9b 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.5 2007/02/05 11:10:02 adam Exp $
+$NetBSD: distinfo,v 1.6 2007/02/08 20:00:27 adam Exp $
 
-SHA1 (postgresql-8.2.2.tar.bz2) = 6419677afd0cc3a93070e966bdf449094d2110f0
-RMD160 (postgresql-8.2.2.tar.bz2) = 8cf5305a92a0253387bfeb49ecfe1826e33d62f9
-Size (postgresql-8.2.2.tar.bz2) = 12472390 bytes
+SHA1 (postgresql-8.2.3.tar.bz2) = 6b536fb9b120101b742adb6b5f8a7983b476d386
+RMD160 (postgresql-8.2.3.tar.bz2) = f5bb7182b8a5901ef03292c30c72762366c78ff6
+Size (postgresql-8.2.3.tar.bz2) = 12471567 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = c602b4c381c730368c19fb5ab765c69c7b5573bb
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9