Changes 8.1.9:

* Support explicit placement of the temporary-table schema within
  search_path, and disable searching it for functions and operators
* "/contrib/tsearch2" crash fixes
* Require "COMMIT PREPARED" to be executed in the same database as
  the transaction was prepared in
* Fix potential-data-corruption bug in how "VACUUM FULL" handles
  "UPDATE" chains
* Planner fixes, including improving outer join and bitmap scan
  selection logic
* Fix PANIC during enlargement of a hash index (bug introduced in
  8.1.6)
* Fix POSIX-style timezone specs to follow new USA DST rules

4 files changed, 22 insertions, 9 deletions

diff --git a/databases/postgresql81-client/PLIST b/databases/postgresql81-client/PLIST
index dd3ed1996f7..999c227f057 100644
--- a/databases/postgresql81-client/PLIST
+++ b/databases/postgresql81-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2007/02/08 20:00:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2007/04/30 13:37:22 adam Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -987,6 +987,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-15.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-4.html
@@ -1004,6 +1005,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-13.html
 ${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-2.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-3.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-4.html
@@ -1017,6 +1019,7 @@ ${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-13.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
@@ -1033,6 +1036,7 @@ ${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.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql81-server/PLIST b/databases/postgresql81-server/PLIST
index 4f8c6305e2e..0db9c64e436 100644
--- a/databases/postgresql81-server/PLIST
+++ b/databases/postgresql81-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2007/01/08 18:55:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2007/04/30 13:37:22 adam Exp $
 ${PG_SUBPREFIX}bin/postgres
 ${PG_SUBPREFIX}bin/postmaster
 ${PG_SUBPREFIX}lib/postgresql/ascii_and_mic.la
@@ -63,6 +63,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Abidjan
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Accra
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Addis_Ababa
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Algiers
+${PG_SUBPREFIX}share/postgresql/timezone/Africa/Asmara
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Asmera
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bamako
 ${PG_SUBPREFIX}share/postgresql/timezone/Africa/Bangui
@@ -184,6 +185,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Marengo
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Petersburg
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vevay
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Vincennes
+${PG_SUBPREFIX}share/postgresql/timezone/America/Indiana/Winamac
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Indianapolis
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Moncton
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Inuvik
@@ -232,6 +234,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/America/Rainy_River
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Rankin_Inlet
 ${PG_SUBPREFIX}share/postgresql/timezone/America/Recife
 ${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/Santiago
@@ -360,6 +363,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Bermuda
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Canary
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Cape_Verde
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Faeroe
+${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Faroe
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Jan_Mayen
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Madeira
 ${PG_SUBPREFIX}share/postgresql/timezone/Atlantic/Reykjavik
@@ -373,6 +377,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Broken_Hill
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Canberra
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Currie
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Darwin
+${PG_SUBPREFIX}share/postgresql/timezone/Australia/Eucla
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Hobart
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/LHI
 ${PG_SUBPREFIX}share/postgresql/timezone/Australia/Lindeman
@@ -611,6 +616,7 @@ ${PG_SUBPREFIX}share/postgresql/timezone/Universal
 ${PG_SUBPREFIX}share/postgresql/timezone/W-SU
 ${PG_SUBPREFIX}share/postgresql/timezone/WET
 ${PG_SUBPREFIX}share/postgresql/timezone/Zulu
+${PG_SUBPREFIX}share/postgresql/timezone/posixrules
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/US
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Pacific
 @dirrm ${PG_SUBPREFIX}share/postgresql/timezone/Mideast
diff --git a/databases/postgresql81/Makefile.common b/databases/postgresql81/Makefile.common
index d3191d335cb..0353bc753e0 100644
--- a/databases/postgresql81/Makefile.common
+++ b/databases/postgresql81/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2007/02/08 20:00:46 adam Exp $
+# $NetBSD: Makefile.common,v 1.11 2007/04/30 13:37:22 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -19,7 +19,10 @@ EXTRACT_SUFX=	.tar.bz2
 MAINTAINER?=	jlam@NetBSD.org
 HOMEPAGE?=	http://www.postgresql.org/
 
-CONFLICTS+=	postgresql-[0-9]* postgresql73-* postgresql74-* postgresql80-*
+CONFLICTS+=	postgresql-[0-9]*
+CONFLICTS+=	postgresql73-[0-9]*
+CONFLICTS+=	postgresql80-[0-9]*
+CONFLICTS+=	postgresql82-[0-9]*
 
 DISTINFO_FILE?=		${.CURDIR}/../postgresql81/distinfo
 COMMON_FILESDIR?=	${.CURDIR}/../postgresql81/files
@@ -32,7 +35,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql81/patches
 #
 # Note: Do not forget jdbc-postgresql81 when updating version
 #
-DIST_VERS?=		8.1.8
+DIST_VERS?=		8.1.9
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql81-client+=	postgresql81-client>=${BASE_VERS}
diff --git a/databases/postgresql81/distinfo b/databases/postgresql81/distinfo
index e85acad5f99..32f89e6cc60 100644
--- a/databases/postgresql81/distinfo
+++ b/databases/postgresql81/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.8 2007/02/08 20:00:46 adam Exp $
+$NetBSD: distinfo,v 1.9 2007/04/30 13:37:22 adam Exp $
 
-SHA1 (postgresql-8.1.8.tar.bz2) = 1981d2a1ff1146bb74c713210b12e623312de600
-RMD160 (postgresql-8.1.8.tar.bz2) = 693ca1d84f52331f2bfbd11122f8ce4c6a807dfa
-Size (postgresql-8.1.8.tar.bz2) = 11702893 bytes
+SHA1 (postgresql-8.1.9.tar.bz2) = ba0b09ce916ee19a3cc6eb9f614bc05c7babc5ac
+RMD160 (postgresql-8.1.9.tar.bz2) = ab86aac72e6ecdc5806da14afd877d86ace0a626
+Size (postgresql-8.1.9.tar.bz2) = 11723124 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = 5bf5f46e86025772cbdb9c9d22c942b40288f82f
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9