Update postgresql with latest patch release.

A critical fix repairs an error in ReadBuffer that can cause data loss
due to overwriting recently-added pages.  This applies to the 8.1 and
8.0 branches on all platforms.

Note that this update might require a reindex of textual columns under
certain conditions; please see UPDATING.

Other fixes included are:
-- Character string locale comparison bug. This may require a REINDEX
    on text column indexes in some locales, such as Hungarian.
-- Prevent accidental changes of locale by plperl
-- Two fixes for Japanese encodings
-- Two fixes for COPY CSV
-- Fixes for functions returning RECORD
-- Fixes to autovacuum, dblink and pgcrypto

3 files changed, 22 insertions, 19 deletions

diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index bb8c0681dd69..737455191e62 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -7,8 +7,8 @@
 
 PORTNAME?=	postgresql
 PKGNAMESUFFIX?=	-server
-PORTVERSION?=	8.0.5
-PORTREVISION?=	1
+PORTVERSION?=	8.0.6
+PORTREVISION?=	0
 CATEGORIES?=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL}
 MASTER_SITE_SUBDIR=	source/v${PORTVERSION}
@@ -112,7 +112,7 @@ USE_AUTOTOOLS=	autoconf:253
 CONFIGURE_ARGS+=--with-icu
 LIB_DEPENDS=	icudata.34:${PORTSDIR}/devel/icu
 PATCH_SITES+=	http://people.freebsd.org/~girgen/postgresql-icu/:icu
-PATCHFILES+=	pg-803-icu-34-2005-10-27.diff.gz:icu
+PATCHFILES+=	pg-806-icu-34-2006-01-09.diff.gz:icu
 .  endif
 
 PATCH_DIST_STRIP=-p1
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index 3b8b51a2ef2e..a61340569dd0 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,18 +1,18 @@
-MD5 (postgresql/postgresql-base-8.0.5.tar.bz2) = bac4dfcd3b33124ba63f1c7a3ae49586
-SHA256 (postgresql/postgresql-base-8.0.5.tar.bz2) = f844241e7066de5e9d21b0f498b1f93d3e2c470afe390b27907783d6656f6a87
-SIZE (postgresql/postgresql-base-8.0.5.tar.bz2) = 7826109
-MD5 (postgresql/postgresql-docs-8.0.5.tar.bz2) = 1b6b3013f6098d2fddbeced56f38305a
-SHA256 (postgresql/postgresql-docs-8.0.5.tar.bz2) = b0e890797a4f9e127b9ba0d417722dac19137fcc113600ff93304fe521cfc2a6
-SIZE (postgresql/postgresql-docs-8.0.5.tar.bz2) = 2247707
-MD5 (postgresql/postgresql-opt-8.0.5.tar.bz2) = 77bb201d264ab5d34e6812bd0a615679
-SHA256 (postgresql/postgresql-opt-8.0.5.tar.bz2) = 2990b3e382233c66ef3f8138f2826f38007c15269454c51ce0be9a8da8295840
-SIZE (postgresql/postgresql-opt-8.0.5.tar.bz2) = 133847
-MD5 (postgresql/postgresql-test-8.0.5.tar.bz2) = 0cb4ccdc6fea7b4d34456f0dca541d42
-SHA256 (postgresql/postgresql-test-8.0.5.tar.bz2) = a6234dfe58b88ad1994b7c2548150bab7c7a8a9033a0a0d934e2b5e16cd401e6
-SIZE (postgresql/postgresql-test-8.0.5.tar.bz2) = 959676
+MD5 (postgresql/postgresql-base-8.0.6.tar.bz2) = 106faa96ca820ca7fb55936db394996b
+SHA256 (postgresql/postgresql-base-8.0.6.tar.bz2) = 3916a87c20f2f947bf4a546059d7b3fee714f8dbaf3630bd1265032ba29012d3
+SIZE (postgresql/postgresql-base-8.0.6.tar.bz2 = 7825582
+MD5 (postgresql/postgresql-docs-8.0.6.tar.bz2) = 3d289f9aad770a22293caf293bc9da9e
+SHA256 (postgresql/postgresql-docs-8.0.6.tar.bz2) = 8d337bf5d1616dc615469e49a6763a5d4e3e06565e6c02e00533e2a663d119a7
+SIZE (postgresql/postgresql-docs-8.0.6.tar.bz2 = 2251094
+MD5 (postgresql/postgresql-opt-8.0.6.tar.bz2) = 4ce9485061082e9d837735071f7b03d6
+SHA256 (postgresql/postgresql-opt-8.0.6.tar.bz2) = dddfd91f46611961428541682b55225f8204a4d00246b6d672bf36228e58959c
+SIZE (postgresql/postgresql-opt-8.0.6.tar.bz2 = 133985
+MD5 (postgresql/postgresql-test-8.0.6.tar.bz2) = 3aa1d7885aa5d83c2d31ae0b90c411c2
+SHA256 (postgresql/postgresql-test-8.0.6.tar.bz2) = 2a528bb2112792db6152fd1ecccdcd81ec789f1ca776b18c1cd525b9df66548d
+SIZE (postgresql/postgresql-test-8.0.6.tar.bz2 = 958354
 MD5 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 9fa75cd7b3f1cb913d2e6d310582a4bc
 SHA256 (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = f3a1849f2d527759ef721502cb445a435e072cc9be820c2e489c9e4a71c7adbe
 SIZE (postgresql/hier-Pg8.0.3-0.5.5.diff.gz) = 30555
-MD5 (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 277f3fb5e6f69c17cf4da9fa13b67d43
-SHA256 (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 08f35cf47d2c58d0ade31b8b36a1de740047b0c8aa22e66c8caef0bd1d8277a0
-SIZE (postgresql/pg-803-icu-34-2005-10-27.diff.gz) = 4191
+MD5 (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = b5d127a071c7165395ed042512d09159
+SHA256 (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = 7faabd28b0c82ba78daa089092618c51d86157ea1eb4b7ca7bc6c002c8c0733a
+SIZE (postgresql/pg-806-icu-34-2006-01-09.diff.gz) = 4372
diff --git a/databases/postgresql80-server/pkg-plist-client b/databases/postgresql80-server/pkg-plist-client
index 5810e57ecead..3d4497fcdbd7 100644
--- a/databases/postgresql80-server/pkg-plist-client
+++ b/databases/postgresql80-server/pkg-plist-client
@@ -420,12 +420,15 @@ lib/libpq.so.4
 lib/libpgtypes.a
 lib/libpgtypes.so
 lib/libpgtypes.so.2
+lib/postgresql/pgxs/config/install-sh
+lib/postgresql/pgxs/config/mkinstalldirs
 lib/postgresql/pgxs/src/makefiles/pgxs.mk
-@dirrm lib/postgresql/pgxs/src/makefiles
 lib/postgresql/pgxs/src/Makefile.global
 lib/postgresql/pgxs/src/Makefile.port
 lib/postgresql/pgxs/src/Makefile.shlib
 lib/postgresql/pgxs/src/nls-global.mk
+@dirrm lib/postgresql/pgxs/src/makefiles
+@dirrm lib/postgresql/pgxs/config
 @dirrm lib/postgresql/pgxs/src
 @dirrm lib/postgresql/pgxs
 @dirrm lib/postgresql