Changes 8.4.5:

* 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 placement of placeholder evaluation
* Fix possible duplicate scans of UNION ALL member relations
* Fix "cannot handle unplanned sub-select" error
* Fix mishandling of whole-row Vars that reference a view or sub-select and
  appear within a nested sub-select
* Fix mishandling of cross-type IN comparisons
* Fix computation of "ANALYZE" statistics for tsvector columns
* Improve planner's estimate of memory used by array_agg(), string_agg(), and
  similar aggregate functions
* 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
* Fix incorrect search logic for partial-match queries with GIN indexes
* 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 corruption of pending trigger event lists during subtransaction
  rollback
* 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
* Prevent misinterpretation of partially-specified relation options
  for TOAST tables
* Fix inheritance count tracking in "ALTER TABLE ... ADD CONSTRAINT"
* 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
* Improve "CREATE INDEX"'s checking of whether proposed index
  expressions are immutable
* 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 _

2 files changed, 24 insertions, 7 deletions

diff --git a/databases/postgresql84-client/Makefile b/databases/postgresql84-client/Makefile
index 02833331d5a..a803d26880c 100644
--- a/databases/postgresql84-client/Makefile
+++ b/databases/postgresql84-client/Makefile
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.8 2010/05/20 12:36:39 adam Exp $
+# $NetBSD: Makefile,v 1.9 2010/10/07 15:53:22 adam Exp $
 
 PKGNAME=	postgresql84-client-${BASE_VERS}
 COMMENT=	PostgreSQL database client programs
@@ -85,8 +85,7 @@ post-wrapper:
 
 post-install:
 	cd ${WRKSRC}/doc; for file in					\
-		FAQ* KNOWN_BUGS MISSING_FEATURES README.* TODO		\
-		bug.template;						\
+		KNOWN_BUGS MISSING_FEATURES README.* TODO bug.template;	\
 	do								\
 		${INSTALL_DATA} $$file ${DESTDIR}${PG_DOC_DIR}/$$file;	\
         done;								\
diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index 102ea238f6d..520b3bc0ad1 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2010/05/20 12:36:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2010/10/07 15:53:22 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -674,7 +674,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
@@ -791,7 +790,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.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
@@ -1235,6 +1233,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
@@ -1260,6 +1259,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
@@ -1282,6 +1282,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
@@ -1299,6 +1300,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
@@ -1311,6 +1313,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
@@ -1324,6 +1327,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-4.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
@@ -1333,7 +1337,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
@@ -1364,6 +1367,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
@@ -1721,12 +1725,16 @@ ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/pg_dump-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/pg_resetxlog-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/pgscripts-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/psql-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/ecpg-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/initdb-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/libpq5-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pg_config-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pg_controldata-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pg_ctl-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pg_dump-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pg_resetxlog-8.4.mo
 ${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/pgscripts-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/psql-8.4.mo
 ${PG_SUBPREFIX}share/locale/nb/LC_MESSAGES/pg_config-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/ecpg-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/ecpglib6-8.4.mo
@@ -1785,5 +1793,15 @@ ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/pg_dump-8.4.mo
 ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-8.4.mo
 ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/pgscripts-8.4.mo
 ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/psql-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/ecpg-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/initdb-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/libpq5-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pg_config-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pg_controldata-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pg_ctl-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pg_dump-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pg_resetxlog-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/pgscripts-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/psql-8.4.mo
 ${PG_SUBPREFIX}share/postgresql/pg_service.conf.sample
 ${PG_SUBPREFIX}share/postgresql/psqlrc.sample