Changes 8.4.1:

* Fix WAL page header initialization at the end of archive recovery
* Fix "cannot make new WAL entries during recovery" error
* Fix problem that could make expired rows visible after a crash
* Disallow "RESET ROLE" and "RESET SESSION AUTHORIZATION" inside
  security-definer functions
* Make "LOAD" of an already-loaded loadable module into a no-op
* Make window function PARTITION BY and ORDER BY items always be
  interpreted as simple expressions
* Fix several errors in planning of semi-joins
* Fix handling of whole-row references to subqueries that are within
  an outer join
* Fix Windows shared-memory allocation code
* Fix locale handling with plperl
* Fix handling of reloptions to ensure setting one option doesn't
  force default values for others
* Ensure that a "fast shutdown" request will forcibly terminate open
  sessions, even if a "smart shutdown" was already in progress
* Avoid memory leak for array_agg() in GROUP BY queries
* Treat to_char(..., 'TH') as an uppercase ordinal suffix with 'HH'/'HH12'

7 files changed, 32 insertions, 23 deletions

diff --git a/databases/postgresql84-client/PLIST b/databases/postgresql84-client/PLIST
index 4b2ae20f2ca..d210427701b 100644
--- a/databases/postgresql84-client/PLIST
+++ b/databases/postgresql84-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:27:58 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:19 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -206,6 +206,7 @@ ${PG_SUBPREFIX}include/postgresql/server/executor/spi.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/spi_priv.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/tstoreReceiver.h
 ${PG_SUBPREFIX}include/postgresql/server/executor/tuptable.h
+${PG_SUBPREFIX}include/postgresql/server/foreign/foreign.h
 ${PG_SUBPREFIX}include/postgresql/server/fmgr.h
 ${PG_SUBPREFIX}include/postgresql/server/funcapi.h
 ${PG_SUBPREFIX}include/postgresql/server/getaddrinfo.h
@@ -656,18 +657,6 @@ ${PG_SUBPREFIX}man/man7/update.7
 ${PG_SUBPREFIX}man/man7/vacuum.7
 ${PG_SUBPREFIX}man/man7/values.7
 ${PG_SUBPREFIX}man/man7/with.7
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_brazilian
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_chinese_simp
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_chinese_trad
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_czech
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_farsi
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_french
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_german
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_hungarian
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_japanese
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_polish
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_russian
-${PG_SUBPREFIX}share/doc/postgresql/FAQ_turkish
 ${PG_SUBPREFIX}share/doc/postgresql/KNOWN_BUGS
 ${PG_SUBPREFIX}share/doc/postgresql/MISSING_FEATURES
 ${PG_SUBPREFIX}share/doc/postgresql/README.mb.big5
@@ -1235,6 +1224,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-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-5.html
@@ -1257,6 +1247,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-19.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-2.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-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-5.html
@@ -1274,6 +1265,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
@@ -1288,6 +1280,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
@@ -1304,7 +1297,9 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-3.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-4-1.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
@@ -1680,6 +1675,16 @@ ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/pg_dump-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/pg_resetxlog-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/pgscripts-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/psql-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/ecpg-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/ecpglib6-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/initdb-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/libpq5-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pg_config-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pg_controldata-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pg_ctl-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pg_resetxlog-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pgscripts-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/psql-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/ecpg-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/ecpglib6-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/initdb-8.4.mo
diff --git a/databases/postgresql84-plperl/PLIST b/databases/postgresql84-plperl/PLIST
index 679eb8143bb..dccacf2ae03 100644
--- a/databases/postgresql84-plperl/PLIST
+++ b/databases/postgresql84-plperl/PLIST
@@ -1,8 +1,9 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:30:06 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:19 adam Exp $
 ${PG_SUBPREFIX}lib/postgresql/plperl.la
 ${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/plperl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/plperl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/plperl0-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/plperl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/plperl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/plperl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/plperl0-8.4.mo
diff --git a/databases/postgresql84-plpython/PLIST b/databases/postgresql84-plpython/PLIST
index d50df87875a..21522f7783e 100644
--- a/databases/postgresql84-plpython/PLIST
+++ b/databases/postgresql84-plpython/PLIST
@@ -1,8 +1,9 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:30:30 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:19 adam Exp $
 ${PG_SUBPREFIX}lib/postgresql/plpython.la
 ${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/plpython0-8.4.mo
 ${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/plpython0-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/plpython0-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/plpython0-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/plpython0-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/plpython0-8.4.mo
 ${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/plpython0-8.4.mo
diff --git a/databases/postgresql84-pltcl/PLIST b/databases/postgresql84-pltcl/PLIST
index 44cabb93b1c..75f8325cf27 100644
--- a/databases/postgresql84-pltcl/PLIST
+++ b/databases/postgresql84-pltcl/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:30:56 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:20 adam Exp $
 ${PG_SUBPREFIX}bin/pltcl_delmod
 ${PG_SUBPREFIX}bin/pltcl_listmod
 ${PG_SUBPREFIX}bin/pltcl_loadmod
@@ -7,6 +7,7 @@ ${PG_SUBPREFIX}share/postgresql/unknown.pltcl
 ${PG_SUBPREFIX}share/locale/de/LC_MESSAGES/pltcl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/pltcl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/pltcl0-8.4.mo
+${PG_SUBPREFIX}share/locale/it/LC_MESSAGES/pltcl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/ja/LC_MESSAGES/pltcl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/pt_BR/LC_MESSAGES/pltcl0-8.4.mo
 ${PG_SUBPREFIX}share/locale/tr/LC_MESSAGES/pltcl0-8.4.mo
diff --git a/databases/postgresql84-server/PLIST b/databases/postgresql84-server/PLIST
index 38234dfa021..934e865e855 100644
--- a/databases/postgresql84-server/PLIST
+++ b/databases/postgresql84-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2009/07/29 06:29:02 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2009/09/10 10:06:20 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -36,6 +36,7 @@ ${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/plpgsql0-8.4.mo
 ${PG_SUBPREFIX}share/locale/es/LC_MESSAGES/postgres-8.4.mo
 ${PG_SUBPREFIX}share/locale/fr/LC_MESSAGES/plpgsql0-8.4.mo
 ${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/pt_BR/LC_MESSAGES/postgres-8.4.mo
diff --git a/databases/postgresql84/Makefile.common b/databases/postgresql84/Makefile.common
index 36f6378305d..4efeebf2c1b 100644
--- a/databases/postgresql84/Makefile.common
+++ b/databases/postgresql84/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.1.1.1 2009/07/29 06:26:17 adam Exp $
+# $NetBSD: Makefile.common,v 1.2 2009/09/10 10:06:19 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -38,7 +38,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql84/patches
 #
 # Note: Do not forget jdbc-postgresql84 when updating version
 #
-DIST_VERS?=		8.4.0
+DIST_VERS?=		8.4.1
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql84-client+=	postgresql84-client>=${BASE_VERS}
diff --git a/databases/postgresql84/distinfo b/databases/postgresql84/distinfo
index e8a3ee747d5..d0dc564ce9b 100644
--- a/databases/postgresql84/distinfo
+++ b/databases/postgresql84/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.1.1.1 2009/07/29 06:26:17 adam Exp $
+$NetBSD: distinfo,v 1.2 2009/09/10 10:06:19 adam Exp $
 
-SHA1 (postgresql-8.4.0.tar.bz2) = 7a4776155049b8343f3b3b2e071002bb9db47f44
-RMD160 (postgresql-8.4.0.tar.bz2) = 7b0a3b6d6c6c67479a1de2d8a3efb3a27e50fe2e
-Size (postgresql-8.4.0.tar.bz2) = 13839282 bytes
+SHA1 (postgresql-8.4.1.tar.bz2) = e6903f0029402ef8fb12645a177204499ea5b2b7
+RMD160 (postgresql-8.4.1.tar.bz2) = ad03c250afd71091294a2a3e67d96b661883db87
+Size (postgresql-8.4.1.tar.bz2) = 13579302 bytes
 SHA1 (patch-aa) = aeeeaafb38e75d8e8f6639280e997ba4c905b45f
 SHA1 (patch-ab) = 3cf9c7f0f812d2e41681281538c3f707cec232c3
 SHA1 (patch-ac) = 0b82797d0b80bdd1e9b5f3de4989fe3848adf6cb