Update PostgreSQL to 7.3.15, 7.4.13, 8.0.8 and 8.1.4 respectively.

Common to all versions:
     * Change the server to reject invalidly-encoded multibyte characters
       in all cases (Tatsuo, Tom) While PostgreSQL has been moving in this
       direction for some time, the checks are now applied uniformly to
       all encodings and all textual input, and are now always errors not
       merely warnings. This change defends against SQL-injection attacks
       of the type described in CVE-2006-2313.
     * Reject unsafe uses of \' in string literals As a server-side
       defense against SQL-injection attacks of the type described in
       CVE-2006-2314, the server now only accepts '' and not \' as a
       representation of ASCII single quote in SQL string literals. By
       default, \' is  rejected  only  when  client_encoding is set to a
       client-only encoding (SJIS, BIG5, GBK, GB18030, or UHC), which is
       the scenario in which SQL injection is possible. A new
       configuration parameter backslash_quote is available  to  adjust
       this  behavior  when needed. Note that full security against
       CVE-2006-2314 may require client-side changes; the purpose of
       backslash_quote is in part to make it obvious that insecure clients
       are insecure.
     * Modify libpq's string-escaping routines to be aware of encoding
       considerations This  fixes  libpq-using applications for the
       security issues described in CVE-2006-2313 and CVE-2006-2314.
       Applications that use multiple PostgreSQL connections concurrently
       should migrate to PQescapeStringConn() and PQescapeByteaConn() to
       ensure that escaping is done correctly for the settings in use in
       each database connection. Applications that do string escaping
       "by hand" should be modified to rely on library routines instead.
     * Fix some incorrect encoding conversion functions win1251_to_iso,
       alt_to_iso, euc_tw_to_big5, euc_tw_to_mic, mic_to_euc_tw were all
       broken to varying extents.
     * Clean up stray remaining uses of \' in strings (Bruce, Jan)
     * Fix server to use custom DH SSL parameters correctly (Michael Fuhr)
     * Fix various minor memory leaks

Additionally for 7.4.13 and later:
     * Fix bug that sometimes caused OR'd index scans to miss rows they
       should have returned
     * Fix WAL replay for case where a btree index has been truncated
     * Fix SIMILAR TO for patterns involving | (Tom)
     * Fix for Bonjour on Intel Macs (Ashley Clark)

Additionally for 8.0.8 and 8.1.4:
     * Fix SELECT INTO and CREATE TABLE AS to create tables in the
       default tablespace, not the base directory (Kris Jurka)
     * Fix problem with password prompting on some Win32 systems (Robert
       Kinberg)

Additionally for 8.1.4:
     * Fix weak key selection in pgcrypto (Marko Kreen)
       Errors in fortuna PRNG reseeding logic could cause a predictable
       session key to be selected by pgp_sym_encrypt() in some cases.
       This only affects non-OpenSSL-using builds.
     * Make autovacuum visible in pg_stat_activity (Alvaro)
     * Disable full_page_writes (Tom)
       In certain cases, having full_page_writes off would cause crash
       recovery to fail. A proper fix will appear in 8.2; for now it's
       just disabled.
     * Various planner fixes, particularly for bitmap index scans and
       MIN/MAX optimization (Tom)
     * Fix incorrect optimization in merge join (Tom)
       Outer joins could sometimes emit multiple copies of unmatched
       rows.
     * Fix crash from using and modifying a plpgsql function in the same
       transaction
     * Improve qsort performance (Dann Corbit)
       Currently this code is only used on Solaris.
     * Improve pg_dump's handling of default values for domains
     * Fix pg_dumpall to handle identically-named users and groups
       reasonably (only possible when dumping from a pre-8.1 server) (Tom)
       The user and group will be merged into a single role with LOGIN
       permission. Formerly the merged role wouldn't have LOGIN
       permission, making it unusable as a user.
     * Fix pg_restore -n to work as documented (Tom)

12 files changed, 42 insertions, 31 deletions

diff --git a/databases/postgresql73-docs/PLIST b/databases/postgresql73-docs/PLIST
index a6dc5d1d600..1553abb4bed 100644
--- a/databases/postgresql73-docs/PLIST
+++ b/databases/postgresql73-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2006/02/20 18:34:07 joerg Exp $
+@comment $NetBSD: PLIST,v 1.7 2006/05/26 17:47:58 joerg Exp $
 share/doc/html/postgresql/admin-preface.html
 share/doc/html/postgresql/admin.html
 share/doc/html/postgresql/app-clusterdb.html
@@ -193,9 +193,9 @@ share/doc/html/postgresql/libpq-trace.html
 share/doc/html/postgresql/libpq.html
 share/doc/html/postgresql/ln17992.html
 share/doc/html/postgresql/ln25.html
-share/doc/html/postgresql/ln26703.html
-share/doc/html/postgresql/ln39147.html
-share/doc/html/postgresql/ln53863.html
+share/doc/html/postgresql/ln26782.html
+share/doc/html/postgresql/ln39302.html
+share/doc/html/postgresql/ln54018.html
 share/doc/html/postgresql/ln659.html
 share/doc/html/postgresql/lo-funcs.html
 share/doc/html/postgresql/lo-implementation.html
@@ -395,6 +395,7 @@ share/doc/html/postgresql/release-7-3-10.html
 share/doc/html/postgresql/release-7-3-11.html
 share/doc/html/postgresql/release-7-3-12.html
 share/doc/html/postgresql/release-7-3-13.html
+share/doc/html/postgresql/release-7-3-14.html
 share/doc/html/postgresql/release-7-3-2.html
 share/doc/html/postgresql/release-7-3-3.html
 share/doc/html/postgresql/release-7-3-4.html
diff --git a/databases/postgresql73/Makefile.common b/databases/postgresql73/Makefile.common
index ee127af7df5..64e76383664 100644
--- a/databases/postgresql73/Makefile.common
+++ b/databases/postgresql73/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.18 2006/04/08 19:16:36 jdolecek Exp $
+# $NetBSD: Makefile.common,v 1.19 2006/05/26 17:47:58 joerg Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -33,7 +33,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql73/patches
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
 # Note: Do not forget jdbc-postgresql when updating version
-DIST_VERS?=		7.3.14
+DIST_VERS?=		7.3.15
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql73-lib?=	postgresql73-lib>=${BASE_VERS}
diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo
index 91e93197762..11a852cc45e 100644
--- a/databases/postgresql73/distinfo
+++ b/databases/postgresql73/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.12 2006/02/20 18:34:07 joerg Exp $
+$NetBSD: distinfo,v 1.13 2006/05/26 17:47:58 joerg Exp $
 
-SHA1 (postgresql-7.3.14.tar.gz) = 2fb6e776e96af9bde99db8ba61768ec120bdefaa
-RMD160 (postgresql-7.3.14.tar.gz) = e8777fdca3f79a71af616368e8b1d3f20b04a2b7
-Size (postgresql-7.3.14.tar.gz) = 11308049 bytes
+SHA1 (postgresql-7.3.15.tar.gz) = a3bde1df6c27552a1d813c6cd6836d7b1afbcafc
+RMD160 (postgresql-7.3.15.tar.gz) = 57bdfd6f45485fb696fdb56c565125afcadacbfc
+Size (postgresql-7.3.15.tar.gz) = 11319476 bytes
 SHA1 (patch-aa) = 61fbeb664b0d89c83a36c79cca3fbdc78d6f5059
 SHA1 (patch-ab) = 5e7a555ed0a2fd1c6678600f98f809072663d10e
 SHA1 (patch-ac) = 5a647cc31873ae81a5bd5a6cf4ec6f44a43448e7
diff --git a/databases/postgresql74-docs/PLIST b/databases/postgresql74-docs/PLIST
index c89f770cffb..07ef65803fd 100644
--- a/databases/postgresql74-docs/PLIST
+++ b/databases/postgresql74-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2006/02/21 20:23:49 joerg Exp $
+@comment $NetBSD: PLIST,v 1.6 2006/05/26 17:47:58 joerg Exp $
 share/doc/postgresql/FAQ
 share/doc/postgresql/FAQ_AIX
 share/doc/postgresql/FAQ_DEV
@@ -443,6 +443,7 @@ share/doc/postgresql/release-7-3-11.html
 share/doc/postgresql/release-7-3-12.html
 share/doc/postgresql/release-7-3-13.html
 share/doc/postgresql/release-7-3-14.html
+share/doc/postgresql/release-7-3-15.html
 share/doc/postgresql/release-7-3-2.html
 share/doc/postgresql/release-7-3-3.html
 share/doc/postgresql/release-7-3-4.html
@@ -455,6 +456,7 @@ share/doc/postgresql/release-7-3.html
 share/doc/postgresql/release-7-4-1.html
 share/doc/postgresql/release-7-4-10.html
 share/doc/postgresql/release-7-4-11.html
+share/doc/postgresql/release-7-4-12.html
 share/doc/postgresql/release-7-4-2.html
 share/doc/postgresql/release-7-4-3.html
 share/doc/postgresql/release-7-4-4.html
diff --git a/databases/postgresql74/Makefile.common b/databases/postgresql74/Makefile.common
index 18bd8a12059..6d92f48a22e 100644
--- a/databases/postgresql74/Makefile.common
+++ b/databases/postgresql74/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.35 2006/04/13 18:23:30 jlam Exp $
+# $NetBSD: Makefile.common,v 1.36 2006/05/26 17:47:58 joerg Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -35,7 +35,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql74/patches
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
 # Note: Do not forget jdbc-postgresql when updating version
-DIST_VERS?=		7.4.12
+DIST_VERS?=		7.4.13
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql74-lib?=	postgresql74-lib>=${BASE_VERS}
diff --git a/databases/postgresql74/distinfo b/databases/postgresql74/distinfo
index 74faa972db3..034f7054566 100644
--- a/databases/postgresql74/distinfo
+++ b/databases/postgresql74/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.20 2006/02/21 20:23:49 joerg Exp $
+$NetBSD: distinfo,v 1.21 2006/05/26 17:47:58 joerg Exp $
 
-SHA1 (postgresql-7.4.12.tar.bz2) = fd4e1db4fa3bf1a22d0596337cb1456389ca03e0
-RMD160 (postgresql-7.4.12.tar.bz2) = 9a156c571383d666551439b49fd09ca3a96bed6e
-Size (postgresql-7.4.12.tar.bz2) = 10246537 bytes
+SHA1 (postgresql-7.4.13.tar.bz2) = 32bb03c00e4905d02fc621988d88b075a8a07194
+RMD160 (postgresql-7.4.13.tar.bz2) = 8b107ed07fd44814f8559c4803a95e86176f2b63
+Size (postgresql-7.4.13.tar.bz2) = 10248808 bytes
 SHA1 (patch-aa) = 830a0789195aacd10094e35e7d0d79c5e201491f
 SHA1 (patch-ab) = f44a544c56452bad197a88cb827e88624c54656c
 SHA1 (patch-ac) = 8104ac7631dd8566eb455e479dd59da058b68c8f
diff --git a/databases/postgresql80-client/PLIST b/databases/postgresql80-client/PLIST
index 2e38ad3f023..127c4645bf5 100644
--- a/databases/postgresql80-client/PLIST
+++ b/databases/postgresql80-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2006/02/21 19:05:07 joerg Exp $
+@comment $NetBSD: PLIST,v 1.11 2006/05/26 17:47:58 joerg Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -946,6 +946,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-15.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
@@ -959,6 +960,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-12.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-13.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
@@ -974,6 +976,7 @@ ${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
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-6.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-7.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql80/Makefile.common b/databases/postgresql80/Makefile.common
index 831f2f7a1f1..68050a1cb09 100644
--- a/databases/postgresql80/Makefile.common
+++ b/databases/postgresql80/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.22 2006/04/13 18:23:30 jlam Exp $
+# $NetBSD: Makefile.common,v 1.23 2006/05/26 17:47:58 joerg Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -35,7 +35,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql80/patches
 #
 # Note: Do not forget jdbc-postgresql80 when updating version
 #
-DIST_VERS?=		8.0.7
+DIST_VERS?=		8.0.8
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql80-client+=	postgresql80-client>=${BASE_VERS}
diff --git a/databases/postgresql80/distinfo b/databases/postgresql80/distinfo
index d07ae8cc251..1c1cfff5666 100644
--- a/databases/postgresql80/distinfo
+++ b/databases/postgresql80/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.12 2006/02/21 19:05:07 joerg Exp $
+$NetBSD: distinfo,v 1.13 2006/05/26 17:47:58 joerg Exp $
 
-SHA1 (postgresql-8.0.7.tar.bz2) = 4aaec1bb0ed34c597eb4f1596b48e8725611c406
-RMD160 (postgresql-8.0.7.tar.bz2) = 46f6c3090709942ce18ebcdc2296749f12eda399
-Size (postgresql-8.0.7.tar.bz2) = 11175215 bytes
+SHA1 (postgresql-8.0.8.tar.bz2) = abc9a418fbdb1e101f94912099679206ef6580d1
+RMD160 (postgresql-8.0.8.tar.bz2) = 3769689e62995239ea54e25f1fe6dbe83a6fcced
+Size (postgresql-8.0.8.tar.bz2) = 11165942 bytes
 SHA1 (patch-aa) = d681a5b2bb4dfce4e3db1490b97fed1b99ff445f
 SHA1 (patch-ab) = 1a80710d13723f2c8130d8235bb40c43af9d9ccd
 SHA1 (patch-ac) = 092d96fe2baafe8eef731b45a85d33fc40584044
diff --git a/databases/postgresql81-client/PLIST b/databases/postgresql81-client/PLIST
index 086530dc4a2..5e66a44c139 100644
--- a/databases/postgresql81-client/PLIST
+++ b/databases/postgresql81-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1.1.1 2006/03/20 14:45:51 uebayasi Exp $
+@comment $NetBSD: PLIST,v 1.2 2006/05/26 17:47:58 joerg Exp $
 ${PG_SUBPREFIX}bin/clusterdb
 ${PG_SUBPREFIX}bin/createdb
 ${PG_SUBPREFIX}bin/createlang
@@ -816,6 +816,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-fastpath.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-notice-processing.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-notify.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-pgpass.html
+${PG_SUBPREFIX}share/doc/postgresql/html/libpq-pgservice.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-ssl.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-status.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/libpq-threading.html
@@ -947,6 +948,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-12.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-13.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-14.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-3-15.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
@@ -960,6 +962,7 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-1.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-10.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-11.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-12.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-7-4-13.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
@@ -976,9 +979,11 @@ ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-4.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-5.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-6.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-7.html
+${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0-8.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-0.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release-8-1-1.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.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/release.html
 ${PG_SUBPREFIX}share/doc/postgresql/html/resources.html
diff --git a/databases/postgresql81/Makefile.common b/databases/postgresql81/Makefile.common
index 0fc809acb07..848b7c0f73a 100644
--- a/databases/postgresql81/Makefile.common
+++ b/databases/postgresql81/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.5 2006/04/13 18:23:30 jlam Exp $
+# $NetBSD: Makefile.common,v 1.6 2006/05/26 17:47:58 joerg Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -32,7 +32,7 @@ PATCHDIR?=		${.CURDIR}/../postgresql81/patches
 #
 # Note: Do not forget jdbc-postgresql81 when updating version
 #
-DIST_VERS?=		8.1.3
+DIST_VERS?=		8.1.4
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_API_DEPENDS.postgresql81-client+=	postgresql81-client>=${BASE_VERS}
diff --git a/databases/postgresql81/distinfo b/databases/postgresql81/distinfo
index a720d62d70e..718d10e565f 100644
--- a/databases/postgresql81/distinfo
+++ b/databases/postgresql81/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.1.1.1 2006/03/20 14:45:49 uebayasi Exp $
+$NetBSD: distinfo,v 1.2 2006/05/26 17:47:58 joerg Exp $
 
-SHA1 (postgresql-8.1.3.tar.bz2) = eed3f7de11e472fb7bf44865a62c18bc6ca9a3b3
-RMD160 (postgresql-8.1.3.tar.bz2) = b9b1461516e2388de41a7892e05d285fa659d87c
-Size (postgresql-8.1.3.tar.bz2) = 11588289 bytes
+SHA1 (postgresql-8.1.4.tar.bz2) = 1bba120ac841ae835ce2749e1f6959086b4530fd
+RMD160 (postgresql-8.1.4.tar.bz2) = 1bed120cb6aa26b2d8664e383f53974a9b0efda4
+Size (postgresql-8.1.4.tar.bz2) = 11609501 bytes
 SHA1 (patch-aa) = a7112ce2e9fc28f638afcf2e196d3cdc0f4c254d
 SHA1 (patch-ab) = 8d09f4e274aeb4ac2b15db73e7801376a5627d27
 SHA1 (patch-ac) = cbd302a60d43171854c37171b57ee7bbf1194ad9