Changes 8.2.5:

* Prevent index corruption when a transaction inserts rows and then
  aborts close to the end of a concurrent "VACUUM" on the same table
* Fix ALTER DOMAIN ADD CONSTRAINT for cases involving domains over
  domains
* Make "CREATE DOMAIN ... DEFAULT NULL" work properly
* Fix some planner problems with outer joins, notably poor size
  estimation for t1 LEFT JOIN t2 WHERE t2.col IS NULL
* Allow the interval data type to accept input consisting only of
  milliseconds or microseconds
* Allow timezone name to appear before the year in timestamp input
* Fixes for GIN indexes used by "/contrib/tsearch2"
* Speed up rtree index insertion
* Fix excessive logging of SSL error messages
* Fix logging so that log messages are never interleaved when using
  the syslogger process
* Fix crash when log_min_error_statement logging runs out of memory
* Fix incorrect handling of some foreign-key corner cases
* Fix stddev_pop(numeric) and var_pop(numeric)
* Prevent "REINDEX" and "CLUSTER" from failing due to attempting to
  process temporary tables of other sessions
* Update the time zone database rules, particularly New Zealand's
  upcoming changes
* Windows socket and semaphore improvements
* Make "pg_ctl -w" work properly in Windows service mode
* Fix memory allocation bug when using MIT Kerberos on Windows
* Suppress timezone name (%Z) in log timestamps on Windows because of
  possible encoding mismatches
* Require non-superusers who use "/contrib/dblink" to use only
  password authentication, as a security measure
* Restrict "/contrib/pgstattuple" functions to superusers, for
  security reasons
* Do not let "/contrib/intarray" try to make its GIN opclass the
  default (this caused problems at dump/restore)

4 files changed, 15 insertions, 9 deletions

diff --git a/databases/postgresql82-client/PLIST b/databases/postgresql82-client/PLIST
index ab6a8162c44..859d89d805b 100644
--- a/databases/postgresql82-client/PLIST
+++ b/databases/postgresql82-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2007/04/30 13:37:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2007/09/19 20:02:12 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
@@ -1172,6 +1172,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-17.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-18.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-19.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-20.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-4.html
@@ -1190,6 +1191,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-14.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-15.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-16.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-17.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-18.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
@@ -1204,6 +1206,7 @@ ${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-13.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-14.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,6 +1217,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-9.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-1.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-10.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
@@ -1228,6 +1232,7 @@ ${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-8-2-4.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-2-5.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
@@ -1493,7 +1498,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/x71171.html
+${PG_SUBPREFIX}share/doc/postgresql/html/x71187.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-server/PLIST b/databases/postgresql82-server/PLIST
index 0bc85246dac..e432688c3d2 100644
--- a/databases/postgresql82-server/PLIST
+++ b/databases/postgresql82-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2007/04/30 13:37:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2007/09/19 20:02:12 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -180,6 +180,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Indianapolis
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Knox
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Marengo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Petersburg
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Tell_City
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vevay
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vincennes
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Winamac
diff --git a/databases/postgresql82/Makefile.common b/databases/postgresql82/Makefile.common
index 711adfe86b7..0d737476187 100644
--- a/databases/postgresql82/Makefile.common
+++ b/databases/postgresql82/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.6 2007/05/04 19:45:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.7 2007/09/19 20:02:12 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.4
+DIST_VERS?=		8.2.5
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql82-client+=	postgresql82-client>=${BASE_VERS}
diff --git a/databases/postgresql82/distinfo b/databases/postgresql82/distinfo
index 089d19d6e41..79613afddff 100644
--- a/databases/postgresql82/distinfo
+++ b/databases/postgresql82/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.7 2007/04/30 13:37:00 adam Exp $
+$NetBSD: distinfo,v 1.8 2007/09/19 20:02:12 adam Exp $
 
-SHA1 (postgresql-8.2.4.tar.bz2) = 0d54a78b3ef83c2fb29b7109b06f17434e5cf831
-RMD160 (postgresql-8.2.4.tar.bz2) = 216612a33b19dd590c85bfd94e70f29ae1487c3a
-Size (postgresql-8.2.4.tar.bz2) = 12527803 bytes
+SHA1 (postgresql-8.2.5.tar.bz2) = 45ddb77b542e8b279013f374edab65a8860a636d
+RMD160 (postgresql-8.2.5.tar.bz2) = 90e4afd6a2ae5f7203ff8409970c73401171e0ff
+Size (postgresql-8.2.5.tar.bz2) = 12510411 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = c602b4c381c730368c19fb5ab765c69c7b5573bb
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9