Update PostgreSQL 7.4 packages to 7.4.5. Changes are mostly reliability fixes.

Dump/restore is not necessary for 7.4.x users.

Changes in 7.4.5:
    * Repair possible crash during concurrent btree index insertions
       This patch fixes a rare case in which concurrent insertions into a
       btree index could result in a server panic. No permanent damage
       would result, but it's still worth a re-release. The bug does not
       exist in pre-7.4 releases.

Changes in 7.4.4:
     * Prevent possible loss of committed transactions during crash
       Due to insufficient interlocking between transaction commit and
       checkpointing, it was possible for transactions committed just
       before the most recent checkpoint to be lost, in whole or in part,
       following a database crash and restart. This is a serious bug that
       has existed since PostgreSQL 7.1.
     * Check HAVING restriction before evaluating result list of an
       aggregate plan
     * Avoid crash when session's current userID is deleted
     * Fix hashed crosstab for zero-rows case (Joe)
     * Force cache update after renaming a column in a foreign key
     * Pretty-print UNION queries correctly
     * Make psql handle \r\n newlines properly in COPY IN
     * pg_dump handled ACLs with grant options incorrectly
     * Fix thread support for OS X and Solaris
     * Updated JDBC driver (build 215) with various fixes
     * ECPG fixes
     * Translation updates (various contributors)

7 files changed, 20 insertions, 19 deletions

diff --git a/databases/postgresql74-client/Makefile b/databases/postgresql74-client/Makefile
index 98e01d90fa8..24697017de1 100644
--- a/databases/postgresql74-client/Makefile
+++ b/databases/postgresql74-client/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.7 2004/10/03 00:13:23 tv Exp $
+# $NetBSD: Makefile,v 1.8 2004/10/10 07:30:23 jdolecek Exp $
 
 PKGNAME=		postgresql74-client-${BASE_VERS}
-PKGREVISION=		2
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgc
 COMMENT=		PostgreSQL database client programs
 
diff --git a/databases/postgresql74-contrib/Makefile b/databases/postgresql74-contrib/Makefile
index f1bac7bbc20..e937687fcc0 100644
--- a/databases/postgresql74-contrib/Makefile
+++ b/databases/postgresql74-contrib/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.5 2004/10/03 00:13:23 tv Exp $
+# $NetBSD: Makefile,v 1.6 2004/10/10 07:30:23 jdolecek Exp $
 
 PKGNAME=		postgresql74-contrib-${BASE_VERS}
-PKGREVISION=	1
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgc
 COMMENT=		PostgreSQL database contrib programs
 
diff --git a/databases/postgresql74-lib/Makefile b/databases/postgresql74-lib/Makefile
index 2285cd2b6a3..0341d33a189 100644
--- a/databases/postgresql74-lib/Makefile
+++ b/databases/postgresql74-lib/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.9 2004/10/03 00:13:23 tv Exp $
+# $NetBSD: Makefile,v 1.10 2004/10/10 07:30:23 jdolecek Exp $
 
 PKGNAME=		postgresql74-lib-${BASE_VERS}
-PKGREVISION=		2
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgl
 COMMENT=		PostgreSQL database headers and libraries
 
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index ac9c1b5f08c..f864829f04f 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.4 2004/10/03 00:13:23 tv Exp $
+# $NetBSD: Makefile,v 1.5 2004/10/10 07:30:23 jdolecek Exp $
 
 PKGNAME=		postgresql74-server-${BASE_VERS}
-PKGREVISION=	1
+PKGREVISION=		# empty
 SVR4_PKGNAME=		pstgs
 COMMENT=		PostgreSQL database server programs
 
diff --git a/databases/postgresql74/Makefile.common b/databases/postgresql74/Makefile.common
index 04d8e92439b..e0d8af7a5b7 100644
--- a/databases/postgresql74/Makefile.common
+++ b/databases/postgresql74/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.11 2004/08/21 17:27:04 seb Exp $
+# $NetBSD: Makefile.common,v 1.12 2004/10/10 07:30:22 jdolecek Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -11,12 +11,14 @@
 
 DISTNAME?=		postgresql-${DIST_VERS}
 CATEGORIES+=		databases
-MASTER_SITES?=		http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \
-			ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/ \
+MASTER_SITES?=		\
 			ftp://ftp.de.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \
 			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${DIST_VERS}/ \
 			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${DIST_VERS}/ \
-			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/
+			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${DIST_VERS}/ \
+			http://www.postgresql.org/ftpsite/source/v${DIST_VERS}/ \
+			ftp://ftp.postgresql.org/pub/source/v${DIST_VERS}/
+
 EXTRACT_SUFX=		.tar.bz2
 
 MAINTAINER?=		recht@NetBSD.org
@@ -34,7 +36,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.3
+DIST_VERS?=		7.4.5
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_DEPENDS.postgresql74-lib?=	postgresql74-lib>=${BASE_VERS}
diff --git a/databases/postgresql74/distinfo b/databases/postgresql74/distinfo
index 6d87e0dcb3d..7a5d3002e57 100644
--- a/databases/postgresql74/distinfo
+++ b/databases/postgresql74/distinfo
@@ -1,9 +1,7 @@
-$NetBSD: distinfo,v 1.6 2004/07/24 22:44:12 recht Exp $
+$NetBSD: distinfo,v 1.7 2004/10/10 07:30:22 jdolecek Exp $
 
-SHA1 (postgresql-7.4.3.tar.bz2) = 26df04f0a32a482646850d9b34d95509c97cb585
-Size (postgresql-7.4.3.tar.bz2) = 10149755 bytes
-SHA1 (hier-Pg7.4-0.5.3.tar.gz) = 5b99167a9a87130cc2b7f582e28e3aef6f7f67b3
-Size (hier-Pg7.4-0.5.3.tar.gz) = 34662 bytes
+SHA1 (postgresql-7.4.5.tar.bz2) = 42582179398106fb9cfd5fac44f9fc7c614b07ef
+Size (postgresql-7.4.5.tar.bz2) = 10180504 bytes
 SHA1 (patch-aa) = e9b99b04c02b3f04d21144a22489618948c378a8
 SHA1 (patch-ab) = f44a544c56452bad197a88cb827e88624c54656c
 SHA1 (patch-ac) = 39ce96f3ea9fc1167c8d21168fd1536077898d58
diff --git a/doc/CHANGES b/doc/CHANGES
index 69007370507..a5e4e7bc82d 100644
--- a/doc/CHANGES
+++ b/doc/CHANGES
@@ -1,4 +1,4 @@
-$NetBSD: CHANGES,v 1.7385 2004/10/10 03:16:08 reed Exp $
+$NetBSD: CHANGES,v 1.7386 2004/10/10 07:30:22 jdolecek Exp $
 
 Changes to the packages collection and infrastructure in 2004:
 
@@ -4595,3 +4595,4 @@ Changes to the packages collection and infrastructure in 2004:
 	Updated phppgadmin to 3.4.1 [jdolecek 2004-10-09]
 	Added gnugk-2.0.8 [mjl 2004-10-09]
 	Added strace-4.5.7 [reed 2004-10-10]
+	Updated postgresql74 to 7.4.5 [jdolecek 2004-10-10]