summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjoerg <joerg@pkgsrc.org>2006-05-26 17:47:58 +0000
committerjoerg <joerg@pkgsrc.org>2006-05-26 17:47:58 +0000
commit0eb97e720bdfc212422cd1bfd20be813ab0e10d7 (patch)
tree8a97b807d5a353adb40ccd30da343f31be09c326
parent5a1dea0e79cd48804c465f1f4ef24476514b3dd7 (diff)
downloadpkgsrc-0eb97e720bdfc212422cd1bfd20be813ab0e10d7.tar.gz
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)
-rw-r--r--databases/postgresql73-docs/PLIST9
-rw-r--r--databases/postgresql73/Makefile.common4
-rw-r--r--databases/postgresql73/distinfo8
-rw-r--r--databases/postgresql74-docs/PLIST4
-rw-r--r--databases/postgresql74/Makefile.common4
-rw-r--r--databases/postgresql74/distinfo8
-rw-r--r--databases/postgresql80-client/PLIST5
-rw-r--r--databases/postgresql80/Makefile.common4
-rw-r--r--databases/postgresql80/distinfo8
-rw-r--r--databases/postgresql81-client/PLIST7
-rw-r--r--databases/postgresql81/Makefile.common4
-rw-r--r--databases/postgresql81/distinfo8
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