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 _

1 files changed, 13 insertions, 6 deletions

diff --git a/databases/postgresql84-server/PLIST b/databases/postgresql84-server/PLIST
index 53b47065633..658c017e733 100644
--- a/databases/postgresql84-server/PLIST
+++ b/databases/postgresql84-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2010/05/20 12:36:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2010/10/07 15:53:22 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -14,9 +14,9 @@ ${PG_SUBPREFIX}lib/postgresql/latin_and_mic.la
 ${PG_SUBPREFIX}lib/postgresql/plpgsql.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_ascii.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_big5.la
-${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_jis_2004.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_cyrillic.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_cn.la
+${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_jis_2004.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_jp.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_kr.la
 ${PG_SUBPREFIX}lib/postgresql/utf8_and_euc_tw.la
@@ -39,11 +39,16 @@ ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/postgres-8.4.mo
 ${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/postgres-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/plpgsql0-8.4.mo
+${PG_SUBPREFIX}share/locale/ko/LC_MESSAGES/postgres-8.4.mo
+${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/postgres-8.4.mo
 ${PG_SUBPREFIX}share/locale/ro/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/postgres-8.4.mo
 ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/zh_CN/LC_MESSAGES/postgres-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/plpgsql0-8.4.mo
+${PG_SUBPREFIX}share/locale/zh_TW/LC_MESSAGES/postgres-8.4.mo
 ${PG_SUBPREFIX}share/postgresql/conversion_create.sql
 ${PG_SUBPREFIX}share/postgresql/information_schema.sql
 ${PG_SUBPREFIX}share/postgresql/pg_hba.conf.sample
@@ -53,8 +58,8 @@ ${PG_SUBPREFIX}share/postgresql/postgres.description
 ${PG_SUBPREFIX}share/postgresql/postgres.shdescription
 ${PG_SUBPREFIX}share/postgresql/postgresql.conf.sample
 ${PG_SUBPREFIX}share/postgresql/recovery.conf.sample
-${PG_SUBPREFIX}share/postgresql/sql_features.txt
 ${PG_SUBPREFIX}share/postgresql/snowball_create.sql
+${PG_SUBPREFIX}share/postgresql/sql_features.txt
 ${PG_SUBPREFIX}share/postgresql/system_views.sql
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Abidjan
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Accra
@@ -122,15 +127,15 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Jujuy
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/La_Rioja
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Mendoza
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Rio_Gallegos
+${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Salta
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Juan
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/San_Luis
-${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Salta
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Tucuman
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Argentina/Ushuaia
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Aruba
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Asuncion
-${PG_SUBPREFIX}share/postgresql/timezone/America/Atka
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Atikokan
+${PG_SUBPREFIX}share/postgresql/timezone/America/Atka
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Bahia_Banderas
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Barbados
@@ -241,9 +246,9 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Regina
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Resolute
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Rio_Branco
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Rosario
+${PG_SUBPREFIX}share/postgresql/timezone/America/Santa_Isabel
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santarem
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santiago
-${PG_SUBPREFIX}share/postgresql/timezone/America/Santa_Isabel
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Santo_Domingo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Sao_Paulo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Scoresbysund
@@ -566,6 +571,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/PST8PDT
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Apia
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Auckland
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chatham
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Chuuk
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Easter
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Efate
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Enderbury
@@ -591,6 +597,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Noumea
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pago_Pago
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Palau
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pitcairn
+${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Pohnpei
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Ponape
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Port_Moresby
 ${PG_SUBPREFIX}share/postgresql/timezone/Pacific/Rarotonga