Updated databases/postgresql to 7.3.1.

      ==================================================================
      | NOTE:  A dump-and-restore is required to update your databases |
      |        if you wish to update postgresql-server. If your        |
      |        application examines the system catalogs, additional    |
      |        changes will be required due to the introduction of     |
      |        schemas in 7.3; for more information, see:              |
      |                                                                |
      |   http://www.ca.postgresql.org/docs/momjian/upgrade_tips_7.3   |
      ==================================================================

Major changes from version 7.2.3 include:

   Schemas
          Schemas allow users to create objects in separate namespaces,
          so two people or applications can have tables with the same
          name. There is also a public schema for shared tables.
          Table/index creation can be restricted by removing permissions
          on the public schema.

   Drop Column
          PostgreSQL now supports the ALTER TABLE ... DROP COLUMN
          functionality.

   Table Functions
          Functions returning multiple rows and/or multiple columns are
          now much easier to use than before. You can call such a "table
          function" in the SELECT FROM clause, treating its output like a
          table. Also, PL/pgSQL functions can now return sets.

   Prepared Queries
          PostgreSQL now supports prepared queries, for improved
          performance.

   Dependency Tracking
          PostgreSQL now records object dependencies, which allows
          improvements in many areas. "DROP" statements now take either
          CASCADE or RESTRICT to control whether dependent objects are
          also dropped.

   Privileges
          Functions and procedural languages now have privileges, and
          functions can be defined to run with the privileges of their
          creator.

   Internationalization
          Both multibyte and locale support are now always enabled.

   Logging
          A variety of logging options have been enhanced.

   Interfaces
          A large number of interfaces have been moved to
          http://gborg.postgresql.org where they can be developed and
          released independently.

   Functions/Identifiers
          By default, functions can now take up to 32 parameters, and
          identifiers can be up to 63 bytes long. Also, OPAQUE is now
          deprecated: there are specific "pseudo-datatypes" to represent
          each of the former meanings of OPAQUE in function argument and
          result types.

1 files changed, 28 insertions, 26 deletions

diff --git a/databases/postgresql/Makefile.common b/databases/postgresql/Makefile.common
index e8a00e6807b..3360454d3c0 100644
--- a/databases/postgresql/Makefile.common
+++ b/databases/postgresql/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.31 2002/10/19 03:03:49 jlam Exp $
+# $NetBSD: Makefile.common,v 1.32 2003/01/05 20:12:08 jlam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -25,55 +25,47 @@ 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}/../postgresql/distinfo
+COMMON_FILESDIR?=	${.CURDIR}/../postgresql/files
+PATCHDIR?=		${.CURDIR}/../postgresql/patches
 
 # Version numbering scheme:
 #
 # DIST_VERS		version number on the postgresql distfile
 # BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
 #
-DIST_VERS?=		7.2.3
+DIST_VERS?=		7.3.1
 BASE_VERS?=		${DIST_VERS}
 
 BUILDLINK_DEPENDS.postgresql-lib?=	postgresql-lib>=${BASE_VERS}
 BUILDLINK_DEPENDS.tcl-postgresql?=	tcl-postgresql>=${BASE_VERS}
 
+USE_BUILDLINK2=		YES
 USE_GMAKE=		YES
 GNU_CONFIGURE=		YES
+PKG_SYSCONFSUBDIR=	postgresql
 
 .include "../../mk/bsd.prefs.mk"
 
-# PG_MB_ENCODING may be set to any of:
-#
-# SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, UNICODE, MULE_INTERNAL,
-# LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, KOI8, WIN, ALT
-#
-# This variable controls the language encoding on the backend process.
-
-.if defined(PG_MB_ENCODING)
-CONFIGURE_ARGS+=	--enable-multibyte=${PG_MB_ENCODING}
-.else
-CONFIGURE_ARGS+=	--enable-multibyte	# accept default
+PGSQL_TEMPLATE.SunOS=		solaris
+.if !defined(PGSQL_TEMPLATE.${OPSYS})
+PGSQL_TEMPLATE.${OPSYS}=	${LOWER_OPSYS}
 .endif
 
-CONFIGURE_ARGS+=	--disable-odbc
+CONFIGURE_ARGS+=	--with-template="${PGSQL_TEMPLATE.${OPSYS}}"
+CONFIGURE_ARGS+=	--without-readline
+CONFIGURE_ARGS+=	--without-zlib
+
+CONFIGURE_ARGS+=	--includedir=${PREFIX}/include/postgresql
+CONFIGURE_ARGS+=	--sysconfdir=${PKG_SYSCONFDIR}
+CONFIGURE_ARGS+=	--with-htmldir=${PREFIX}/share/doc/html/postgresql
+
 CONFIGURE_ARGS+=	--without-java
 CONFIGURE_ARGS+=	--without-perl
 CONFIGURE_ARGS+=	--without-python
 CONFIGURE_ARGS+=	--without-tcl
 CONFIGURE_ARGS+=	--without-tk
 
-CONFIGURE_ARGS+=	--includedir=${PREFIX}/include/pgsql
-CONFIGURE_ARGS+=	--with-htmldir=${PREFIX}/share/doc/html/postgresql
-
-CONFIGURE_ARGS+=	--disable-readline
-CONFIGURE_ARGS+=	--enable-locale
-CONFIGURE_ARGS+=	--enable-syslog
-CONFIGURE_ARGS+=	--with-CXX
-CONFIGURE_ARGS+=	--with-template="${LOWER_OPSYS}"
-
 post-extract:
 	if [ -d ${WRKSRC}/src ]; then					\
 		${RM} -f ${WRKSRC}/src/Makefile.custom;			\
@@ -85,3 +77,13 @@ post-extract:
 		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq		\
 			${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
 	fi
+	if [ -d ${WRKSRC}/src/interfaces/libpgtcl ]; then		\
+		${RM} -f ${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
+		${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpgtcl	\
+			${WRKSRC}/src/interfaces/libpgtcl/GNUmakefile;	\
+	fi
+
+pre-configure:
+	cd ${WRKSRC} && ${AUTOCONF}
+
+.include "../../mk/autoconf.mk"