Update postgresql and related packages to 7.2. Thanks to Michael Graff

<explorer@flame.org> for most of the work on this update.

Pkgsrc changes from the previous version include removing Makefile.ssl and
some patches that have been integrated into this release of PostgreSQL.  We
leave open the question of when to byte-compile the Python modules for the
PyGreSQL interface and just do it as before, although we should consider
doing the compilation as a post-install step to ensure that the timestamps
are correct.  We also reorder some lines in the Makefile to include
Makefile.common below certain definitions (GNU_CONFIGURE, USE_BUILDLINK_ONLY)
as they may possibly trigger different portions of Makefile.common.

*** Please note that a dump/restore is required to migrate an existing ***
*** PostgreSQL installation to 7.2.                                    ***

Major changes from version 7.1.3 are geared toward improving use in
high-volume applications and include:

   VACUUM
	   Vacuuming no longer locks tables, thus allowing normal user access
           during the vacuum. A new "VACUUM FULL" command does old-style
           vacuum by locking the table and shrinking the on-disk copy of the
           table.

   Transactions
           There is no longer a problem with installations that exceed four
           billion transactions.

   OID's
           OID's are now optional. Users can now create tables without OID's
           for cases where OID usage is excessive.

   Optimizer
           The system now computes histogram column statistics during
           "ANALYZE", allowing much better optimizer choices.

   Security
           A new MD5 encryption option allows more secure storage and
           transfer of passwords. A new Unix-domain socket authentication
           option is available on Linux and BSD systems. PAM authentication
           is also available.

   Statistics
           Administrators can use the new table access statistics module to
           get fine-grained information about table and index usage.

1 files changed, 26 insertions, 24 deletions

diff --git a/databases/postgresql/Makefile.common b/databases/postgresql/Makefile.common
index 1d9bef42b98..9a95df20435 100644
--- a/databases/postgresql/Makefile.common
+++ b/databases/postgresql/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.25 2002/03/12 22:09:35 tv Exp $
+# $NetBSD: Makefile.common,v 1.26 2002/04/04 07:48:20 jlam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution.
@@ -9,36 +9,40 @@
 #	<lang>-postgresql	client-side interface to PostgreSQL
 #	postgresql-<lang>	server-side module for PostgreSQL backend
 
-DISTNAME=		postgresql-${PG_DIST_VERS}
+DISTNAME?=		postgresql-${DIST_VERS}
 CATEGORIES+=		databases
-MASTER_SITES=		http://www.postgresql.org/ftpsite/source/v${PG_DIST_VERS}/ \
-			ftp://ftp.PostgreSQL.org/pub/source/v${PG_DIST_VERS}/ \
-			ftp://ftp.de.postgresql.org/pub/source/v${PG_DIST_VERS}/ \
-			ftp://ch.postgresql.org/mirror/postgresql/source/v${PG_DIST_VERS}/ \
-			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/source/v${PG_DIST_VERS}/ \
-			ftp://looking-glass.usask.ca/pub/postgresql/source/v${PG_DIST_VERS}/ \
-			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/source/v${PG_DIST_VERS}/ \
-			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/source/v${PG_DIST_VERS}/
+PGSQL_SITES=		http://www.postgresql.org/ftpsite/ \
+			ftp://ftp.postgresql.org/pub/ \
+			ftp://ftp.de.postgresql.org/pub/ \
+			ftp://ch.postgresql.org/mirror/postgresql/ \
+			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/ \
+			ftp://looking-glass.usask.ca/pub/postgresql/ \
+			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/ \
+			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/
+MASTER_SITES?=		${PGSQL_SITES:=source/v${DIST_VERS}/}
 
-MAINTAINER=		jlam@netbsd.org
-HOMEPAGE=		http://www.postgresql.org/
+MAINTAINER?=		jlam@netbsd.org
+HOMEPAGE?=		http://www.postgresql.org/
 
 CONFLICTS+=		postgresql-[0-6]* postgresql-7.0*
 
-DISTINFO_FILE=		${.CURDIR}/../../databases/postgresql/distinfo
-COMMON_FILESDIR=	${.CURDIR}/../../databases/postgresql/files
-PATCHDIR=		${.CURDIR}/../../databases/postgresql/patches
+DISTINFO_FILE?=		${.CURDIR}/../../databases/postgresql/distinfo
+COMMON_FILESDIR?=	${.CURDIR}/../../databases/postgresql/files
+PATCHDIR?=		${.CURDIR}/../../databases/postgresql/patches
 
 # Version numbering scheme:
 #
-# PG_DIST_VERS		version number on the postgresql distfile
-# PG_BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
+# DIST_VERS		version number on the postgresql distfile
+# BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
-PG_DIST_VERS=		7.1.3
-PG_BASE_VERS=		${PG_DIST_VERS}
+DIST_VERS?=		7.2
+BASE_VERS?=		${DIST_VERS}
 
-USE_GMAKE=		# defined
-GNU_CONFIGURE=		# defined
+BUILDLINK_DEPENDS.postgresql-lib?=	postgresql-lib>=${BASE_VERS}
+BUILDLINK_DEPENDS.tcl-postgresql?=	tcl-postgresql>=${BASE_VERS}
+
+USE_GMAKE=		YES
+GNU_CONFIGURE=		YES
 
 .include "../../mk/bsd.prefs.mk"
 
@@ -63,7 +67,7 @@ CONFIGURE_ARGS+=	--without-tcl
 CONFIGURE_ARGS+=	--without-tk
 
 CONFIGURE_ARGS+=	--includedir=${PREFIX}/include/pgsql
-CONFIGURE_ARGS+=	--docdir=${PREFIX}/share/doc/html/postgresql
+CONFIGURE_ARGS+=	--with-htmldir=${PREFIX}/share/doc/html/postgresql
 
 CONFIGURE_ARGS+=	--disable-readline
 CONFIGURE_ARGS+=	--enable-locale
@@ -71,8 +75,6 @@ CONFIGURE_ARGS+=	--enable-syslog
 CONFIGURE_ARGS+=	--with-CXX
 CONFIGURE_ARGS+=	--with-template="${LOWER_OPSYS}"
 
-MAKE_ENV+=		CUSTOM_COPT="${CFLAGS}"
-
 post-extract:
 	if [ -d ${WRKSRC}/src ]; then					\
 		${RM} -f ${WRKSRC}/src/Makefile.custom;			\