head	1.44;
access;
symbols
	pkgsrc-2013Q2:1.44.0.48
	pkgsrc-2013Q2-base:1.44
	pkgsrc-2012Q4:1.44.0.46
	pkgsrc-2012Q4-base:1.44
	pkgsrc-2011Q4:1.44.0.44
	pkgsrc-2011Q4-base:1.44
	pkgsrc-2011Q2:1.44.0.42
	pkgsrc-2011Q2-base:1.44
	pkgsrc-2009Q4:1.44.0.40
	pkgsrc-2009Q4-base:1.44
	pkgsrc-2008Q4:1.44.0.38
	pkgsrc-2008Q4-base:1.44
	pkgsrc-2008Q3:1.44.0.36
	pkgsrc-2008Q3-base:1.44
	cube-native-xorg:1.44.0.34
	cube-native-xorg-base:1.44
	pkgsrc-2008Q2:1.44.0.32
	pkgsrc-2008Q2-base:1.44
	pkgsrc-2008Q1:1.44.0.30
	pkgsrc-2008Q1-base:1.44
	pkgsrc-2007Q4:1.44.0.28
	pkgsrc-2007Q4-base:1.44
	pkgsrc-2007Q3:1.44.0.26
	pkgsrc-2007Q3-base:1.44
	pkgsrc-2007Q2:1.44.0.24
	pkgsrc-2007Q2-base:1.44
	pkgsrc-2007Q1:1.44.0.22
	pkgsrc-2007Q1-base:1.44
	pkgsrc-2006Q4:1.44.0.20
	pkgsrc-2006Q4-base:1.44
	pkgsrc-2006Q3:1.44.0.18
	pkgsrc-2006Q3-base:1.44
	pkgsrc-2006Q2:1.44.0.16
	pkgsrc-2006Q2-base:1.44
	pkgsrc-2006Q1:1.44.0.14
	pkgsrc-2006Q1-base:1.44
	pkgsrc-2005Q4:1.44.0.12
	pkgsrc-2005Q4-base:1.44
	pkgsrc-2005Q3:1.44.0.10
	pkgsrc-2005Q3-base:1.44
	pkgsrc-2005Q2:1.44.0.8
	pkgsrc-2005Q2-base:1.44
	pkgsrc-2005Q1:1.44.0.6
	pkgsrc-2005Q1-base:1.44
	pkgsrc-2004Q4:1.44.0.4
	pkgsrc-2004Q4-base:1.44
	pkgsrc-2004Q3:1.44.0.2
	pkgsrc-2004Q3-base:1.44
	pkgsrc-2004Q2:1.42.0.2
	pkgsrc-2004Q2-base:1.42
	pkgsrc-2004Q1:1.41.0.2
	pkgsrc-2004Q1-base:1.41
	pkgsrc-2003Q4:1.39.0.2
	pkgsrc-2003Q4-base:1.39
	netbsd-1-6-1:1.32.0.2
	netbsd-1-6-1-base:1.32
	netbsd-1-6:1.28.0.8
	netbsd-1-6-RELEASE-base:1.28
	pkgviews:1.28.0.4
	pkgviews-base:1.28
	buildlink2:1.28.0.2
	buildlink2-base:1.28
	netbsd-1-5-PATCH003:1.28
	netbsd-1-5-PATCH001:1.11
	netbsd-1-5-RELEASE:1.4
	netbsd-1-4-PATCH003:1.4;
locks; strict;
comment	@# @;


1.44
date	2004.07.24.22.48.13;	author recht;	state dead;
branches;
next	1.43;

1.43
date	2004.06.24.16.50.51;	author darcy;	state Exp;
branches;
next	1.42;

1.42
date	2004.04.24.22.46.09;	author jlam;	state Exp;
branches;
next	1.41;

1.41
date	2004.01.22.08.02.16;	author grant;	state Exp;
branches;
next	1.40;

1.40
date	2004.01.20.14.11.49;	author jlam;	state Exp;
branches;
next	1.39;

1.39
date	2003.08.18.00.26.24;	author cjs;	state Exp;
branches;
next	1.38;

1.38
date	2003.07.17.21.28.50;	author grant;	state Exp;
branches;
next	1.37;

1.37
date	2003.07.11.15.12.06;	author abs;	state Exp;
branches;
next	1.36;

1.36
date	2003.06.25.07.54.31;	author cjs;	state Exp;
branches;
next	1.35;

1.35
date	2003.05.29.08.55.48;	author abs;	state Exp;
branches;
next	1.34;

1.34
date	2003.05.22.07.17.06;	author wiz;	state Exp;
branches;
next	1.33;

1.33
date	2003.02.21.16.09.51;	author mycroft;	state Exp;
branches;
next	1.32;

1.32
date	2003.01.05.20.12.08;	author jlam;	state Exp;
branches;
next	1.31;

1.31
date	2002.10.19.03.03.49;	author jlam;	state Exp;
branches;
next	1.30;

1.30
date	2002.09.26.09.56.07;	author abs;	state Exp;
branches;
next	1.29;

1.29
date	2002.09.01.01.14.29;	author jonb;	state Exp;
branches;
next	1.28;

1.28
date	2002.04.13.06.49.43;	author jlam;	state Exp;
branches;
next	1.27;

1.27
date	2002.04.05.16.27.27;	author jlam;	state Exp;
branches;
next	1.26;

1.26
date	2002.04.04.07.48.20;	author jlam;	state Exp;
branches;
next	1.25;

1.25
date	2002.03.12.22.09.35;	author tv;	state Exp;
branches;
next	1.24;

1.24
date	2001.12.03.08.06.25;	author jlam;	state Exp;
branches;
next	1.23;

1.23
date	2001.10.06.21.41.30;	author veego;	state Exp;
branches;
next	1.22;

1.22
date	2001.09.07.08.49.10;	author jlam;	state Exp;
branches;
next	1.21;

1.21
date	2001.06.12.20.33.02;	author jlam;	state Exp;
branches;
next	1.20;

1.20
date	2001.06.11.06.34.24;	author jlam;	state Exp;
branches;
next	1.19;

1.19
date	2001.06.11.02.05.08;	author jlam;	state Exp;
branches;
next	1.18;

1.18
date	2001.05.29.23.28.05;	author jlam;	state Exp;
branches;
next	1.17;

1.17
date	2001.05.25.14.56.34;	author jlam;	state Exp;
branches;
next	1.16;

1.16
date	2001.05.24.08.54.27;	author jlam;	state Exp;
branches;
next	1.15;

1.15
date	2001.05.16.05.28.55;	author jlam;	state Exp;
branches;
next	1.14;

1.14
date	2001.05.15.15.59.22;	author jlam;	state Exp;
branches;
next	1.13;

1.13
date	2001.05.14.15.45.08;	author jlam;	state Exp;
branches;
next	1.12;

1.12
date	2001.05.14.14.52.36;	author jlam;	state Exp;
branches;
next	1.11;

1.11
date	2001.05.04.01.05.19;	author jlam;	state Exp;
branches;
next	1.10;

1.10
date	2001.04.10.13.08.05;	author jlam;	state Exp;
branches;
next	1.9;

1.9
date	2001.03.27.03.19.49;	author hubertf;	state Exp;
branches;
next	1.8;

1.8
date	2001.02.10.22.37.47;	author jlam;	state Exp;
branches;
next	1.7;

1.7
date	2000.12.11.16.43.11;	author jlam;	state Exp;
branches;
next	1.6;

1.6
date	2000.12.08.17.16.32;	author jlam;	state Exp;
branches;
next	1.5;

1.5
date	2000.12.07.08.29.00;	author mjl;	state Exp;
branches;
next	1.4;

1.4
date	2000.07.14.04.44.11;	author jlam;	state Exp;
branches;
next	1.3;

1.3
date	2000.05.24.09.11.24;	author rh;	state Exp;
branches;
next	1.2;

1.2
date	2000.05.20.19.32.18;	author jlam;	state Exp;
branches;
next	1.1;

1.1
date	2000.03.18.17.43.16;	author jlam;	state Exp;
branches;
next	;


desc
@@


1.44
log
@Delete old postgresql packages now that we have the postgresql73 ones.
@
text
@# $NetBSD: Makefile.common,v 1.43 2004/06/24 16:50:51 darcy Exp $
#
# This Makefile fragment is included by all PostgreSQL packages built from
# the main sources of the PostgreSQL distribution except jdbc-postgresql.
#
# The PostgreSQL package naming scheme, aside from the obvious piecewise
# packages, is as follows:
#
#	<lang>-postgresql	client-side interface to PostgreSQL
#	postgresql-<lang>	server-side module for PostgreSQL backend

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}/ \
			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}/

MAINTAINER?=		tech-pkg@@NetBSD.org
HOMEPAGE?=		http://www.postgresql.org/

CONFLICTS+=		postgresql-[0-6]* postgresql-7.0*

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 -> .)
#
# Note: Do not forget jdbc-postgresql when updating version
DIST_VERS?=		7.3.6
BASE_VERS?=		${DIST_VERS}

BUILDLINK_DEPENDS.postgresql-lib?=	postgresql-lib>=${BASE_VERS}
BUILDLINK_DEPENDS.tcl-postgresql?=	tcl-postgresql>=${BASE_VERS}

USE_GNU_TOOLS+=		make
GNU_CONFIGURE=		YES
PKG_SYSCONFSUBDIR=	postgresql

.include "../../mk/bsd.prefs.mk"

PGSQL_TEMPLATE.SunOS=		solaris
.if !defined(PGSQL_TEMPLATE.${OPSYS})
PGSQL_TEMPLATE.${OPSYS}=	${LOWER_OPSYS}
.endif

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

# Postgresql explicitly forbids any use of -ffast-math
CFLAGS:=		${CFLAGS:S/-ffast-math//}

post-extract:
	if [ -d ${WRKSRC}/src ]; then					\
		${RM} -f ${WRKSRC}/src/Makefile.custom;			\
		${CP} -f ${COMMON_FILESDIR}/Makefile.custom		\
			${WRKSRC}/src/Makefile.custom;			\
	fi
	if [ -d ${WRKSRC}/src/interfaces/libpq ]; then			\
		${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile;	\
		${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"
@


1.43
log
@Upgrade to 7.3.6.

Mostly bug fixes.  The full list of changes can be found at:

7.3.5: http://www.postgresql.org/news/164.html
7.3.6: http://www.postgresql.org/news/172.html

As with all minor release upgrades a dump/restore is not required.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.42 2004/04/24 22:46:09 jlam Exp $
@


1.42
log
@Relinquish maintainership of packages to tech-pkg@@NetBSD.org.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.41 2004/01/22 08:02:16 grant Exp $
d36 1
a36 1
DIST_VERS?=		7.3.4
@


1.41
log
@replace deprecated USE_GMAKE with USE_GNU_TOOLS+=make.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.40 2004/01/20 14:11:49 jlam Exp $
d21 1
a21 1
MAINTAINER?=		jlam@@NetBSD.org
@


1.40
log
@Remove USE_BUILDLINK2 from Makefile.common and distribute the setting to
all of the package Makefiles that include Makefile.common.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.39 2003/08/18 00:26:24 cjs Exp $
d42 1
a42 1
USE_GMAKE=		YES
@


1.39
log
@Upgrade to 7.3.4. The on-disk format is the same, so a dump/restore is
not required. Changes include:
   Repair breakage in timestamp-to-date conversion for dates before 2000
   Prevent rare possibility of server startup failure (Tom)
   Fix bugs in interval-to-time conversion (Tom)
   Add constraint names in a few places in pg_dump (Rod)
   Improve performance of functions with many parameters (Tom)
   Fix to_ascii() buffer overruns (Tom)
   Prevent restore of database comments from throwing an error (Tom)
   Work around buggy strxfrm() present in some Solaris releases (Tom)
   Properly escape jdbc setObject() strings to improve security (Barry)
In particular, the server startup failure mentioned above occurs when the
transaction log ends on a page boundary.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.37 2003/07/11 15:12:06 abs Exp $
a41 1
USE_BUILDLINK2=		YES
@


1.38
log
@s/netbsd.org/NetBSD.org/
@
text
@d36 1
a36 1
DIST_VERS?=		7.3.3
@


1.37
log
@Add a comment to not forget jdbc-postgresql
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.36 2003/06/25 07:54:31 cjs Exp $
d21 1
a21 1
MAINTAINER?=		jlam@@netbsd.org
@


1.36
log
@Update to 7.3.3. About 70 bugfixes; see the HISTORY file for details.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.35 2003/05/29 08:55:48 abs Exp $
d35 1
@


1.35
log
@Since postgresql explicitly checks for and fails if -ffast-math is set in
CFLAGS, strip it out. No package bump as no change in generated package.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.34 2003/05/22 07:17:06 wiz Exp $
d35 1
a35 1
DIST_VERS?=		7.3.2
@


1.34
log
@Update MASTER_SITES, from Ben Collver in PR 21640.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.33 2003/02/21 16:09:51 mycroft Exp $
d66 3
@


1.33
log
@Update postgresql-* to 7.3.2.  Contains numerous bug fixes, including remote
holes.

   Restore creation of OID column in CREATE TABLE AS / SELECT INTO
   Fix pg_dump core dump when dumping views having comments
   Dump DEFERRABLE/INITIALLY DEFERRED constraints properly
   Fix UPDATE when child table's column numbering differs from parent
   Increase default value of max_fsm_relations
   Fix problem when fetching backwards in a cursor for a single-row query
   Make backward fetch work properly with cursor on SELECT DISTINCT query
   Fix problems with loading pg_dump files containing contrib/lo usage
   Fix problem with all-numeric user names
   Fix possible memory leak and core dump during disconnect in libpgtcl
   Make plpython's spi_execute command handle nulls properly (Andrew Bosma)
   Adjust plpython error reporting so that its regression test passes again
   Work with bison 1.875
   Handle mixed-case names properly in plpgsql's %type (Neil)
   Fix core dump in pltcl when executing a query rewritten by a rule
   Repair array subscript overruns (per report from Yichen Xie)
   Reduce MAX_TIME_PRECISION from 13 to 10 in floating-point case
   Correctly case-fold variable names in per-database and per-user settings
   Fix coredump in plpgsql's RETURN NEXT when SELECT into record returns
        no rows
   Fix outdated use of pg_type.typprtlen in python client interface
   Correctly handle fractional seconds in timestamps in JDBC driver
   Improve performance of getImportedKeys() in JDBC
   Make shared-library symlinks work standardly on HPUX (Giles)
   Repair inconsistent rounding behavior for timestamp, time, interval
   SSL negotiation fixes (Nathan Mueller)
   Make libpq's ~/.pgpass feature work when connecting with PQconnectDB
   Update my2pg, ora2pg
   Translation updates
   Add casts between types lo and oid in contrib/lo
   fastpath code now checks for privilege to call function
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.32 2003/01/05 20:12:08 jlam Exp $
d16 1
a16 2
			ftp://ftp.de.postgresql.org/pub/source/v${DIST_VERS}/ \
			ftp://ch.postgresql.org/mirror/postgresql/source/v${DIST_VERS}/ \
a17 1
			ftp://looking-glass.usask.ca/pub/postgresql/source/v${DIST_VERS}/ \
@


1.32
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.31 2002/10/19 03:03:49 jlam Exp $
d37 1
a37 1
DIST_VERS?=		7.3.1
@


1.31
log
@Update databases/postgresql to version 7.2.3.

   This has a variety of fixes from 7.2.2, including fixes to prevent
   possible data loss.

   A dump/restore is *not* required for those running 7.2.X.

Changes from version 7.2.2 include:

 Prevent possible compressed transaction log loss (Tom)
 Prevent non-superuser from increasing most recent vacuum info (Tom)
 Handle pre-1970 date values in newer versions of glibc (Tom)
 Fix possible hang during server shutdown
 Prevent spinlock hangs on SMP PPC machines (Tomoyuki Niijima)
 Fix pg_dump to properly dump FULL JOIN USING (Tom)
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.30 2002/09/26 09:56:07 abs Exp $
d28 3
a30 3
DISTINFO_FILE?=		${.CURDIR}/../../databases/postgresql/distinfo
COMMON_FILESDIR?=	${.CURDIR}/../../databases/postgresql/files
PATCHDIR?=		${.CURDIR}/../../databases/postgresql/patches
d37 1
a37 1
DIST_VERS?=		7.2.3
d43 1
d46 1
d50 8
a57 6
# 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.
d59 3
a61 5
.if defined(PG_MB_ENCODING)
CONFIGURE_ARGS+=	--enable-multibyte=${PG_MB_ENCODING}
.else
CONFIGURE_ARGS+=	--enable-multibyte	# accept default
.endif
a62 1
CONFIGURE_ARGS+=	--disable-odbc
a68 9
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}"

d80 10
@


1.30
log
@add comment that this is not included by jdbc-postgresql
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.29 2002/09/01 01:14:29 jonb Exp $
d37 1
a37 1
DIST_VERS?=		7.2.2
@


1.29
log
@Update to 7.2.2 for security reasons.  Only a security fix since 7.2.1
And create a way to get rid of that stupid message from audit-packages!
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.28 2002/04/13 06:49:43 jlam Exp $
d4 1
a4 1
# the main sources of the PostgreSQL distribution.
@


1.28
log
@Fix problem with MASTER_SITES reported by Dan McMahill in private email.
The make variable expansion differs between 1.5.x make and a -current make,
so simplify it by flattening it out.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.27 2002/04/05 16:27:27 jlam Exp $
d37 1
a37 1
DIST_VERS?=		7.2.1
@


1.27
log
@Update databases/postgresql and related sub-packages to 7.2.1.

*** Please note that a dump/restore is NOT required for those ***
*** running PostgreSQL 7.2.                                   ***

Important changes from version 7.2 include:

 Ensure that sequence counters do not go backwards after a crash (Tom)
 Allow psql \connect to handle mixed case database and user names (Tom)
 Return proper OID on command completion even with ON INSERT rules (Tom)
 Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo)
 Improve handling of multiple UNIONs with different lengths (Tom)
 Fix for array subscripts handling (Tom)
 Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.26 2002/04/04 07:48:20 jlam Exp $
d14 8
a21 9
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}/}
@


1.26
log
@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.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.24 2001/12/03 08:06:25 jlam Exp $
d38 1
a38 1
DIST_VERS?=		7.2
@


1.25
log
@Add directory level "source" to MASTER_SITES.  Only the newest version
(now 7.2, but I'm not in a position to upgrade the whole shebang yet) is
accessible directly form the top distro level.
@
text
@d12 1
a12 1
DISTNAME=		postgresql-${PG_DIST_VERS}
d14 9
a22 8
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}/
d24 2
a25 2
MAINTAINER=		jlam@@netbsd.org
HOMEPAGE=		http://www.postgresql.org/
d29 3
a31 3
DISTINFO_FILE=		${.CURDIR}/../../databases/postgresql/distinfo
COMMON_FILESDIR=	${.CURDIR}/../../databases/postgresql/files
PATCHDIR=		${.CURDIR}/../../databases/postgresql/patches
d35 2
a36 2
# PG_DIST_VERS		version number on the postgresql distfile
# PG_BASE_VERS		pkgsrc-mangled version number (convert pl -> .)
d38 2
a39 2
PG_DIST_VERS=		7.1.3
PG_BASE_VERS=		${PG_DIST_VERS}
d41 5
a45 2
USE_GMAKE=		# defined
GNU_CONFIGURE=		# defined
d70 1
a70 1
CONFIGURE_ARGS+=	--docdir=${PREFIX}/share/doc/html/postgresql
a76 2

MAKE_ENV+=		CUSTOM_COPT="${CFLAGS}"
@


1.24
log
@Use PKGREVISION to manage the package-specific version number when it
differs from the distfile version number.  G/C some the unused variables
in postgresql/Makefile.common related to the old way of handling version
numbers.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.23 2001/10/06 21:41:30 veego Exp $
d14 8
a21 8
MASTER_SITES=		http://www.postgresql.org/ftpsite/v${PG_DIST_VERS}/ \
			ftp://ftp.PostgreSQL.org/pub/v${PG_DIST_VERS}/ \
			ftp://ftp.de.postgresql.org/pub/v${PG_DIST_VERS}/ \
			ftp://ch.postgresql.org/mirror/postgresql/v${PG_DIST_VERS}/ \
			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/v${PG_DIST_VERS}/ \
			ftp://looking-glass.usask.ca/pub/postgresql/v${PG_DIST_VERS}/ \
			ftp://ftp.sunsite.auc.dk/mirrors/postgresql/v${PG_DIST_VERS}/ \
			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/v${PG_DIST_VERS}/
@


1.23
log
@Fix the MASTER_SITES. Some ftp paths changed.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.22 2001/09/07 08:49:10 jlam Exp $
a35 2
# PG_PKG_VERS		pkgsrc revisions of postgresql (nbX, etc.)
# PG_VERS		pkgsrc version number of package
a38 2
PG_PKG_VERS?=		# empty
PG_VERS=		${PG_BASE_VERS}${PG_PKG_VERS}
@


1.22
log
@Update postgresql and packages built from postgresql sources to 7.1.3.
Relevant changes from version 7.1.2 include:

	Remove unused WAL segements of large transactions
	Multiaction rule fix
	Pl/pgSQL memory allocation fix
	VACUUM buffer fix
	pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types
	Fix subselects with DISTINCT ON or LIMIT
	Disable COPY TO/FROM a view
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.21 2001/06/12 20:33:02 jlam Exp $
d16 2
a17 2
			ftp://ftp.de.postgresql.org/v${PG_DIST_VERS}/ \
			ftp://ch.postgresql.org/mirror/postgresql/pub/v${PG_DIST_VERS}/ \
d20 1
a20 1
			ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/v${PG_DIST_VERS}/ \
@


1.21
log
@LIBS is automatically added to CONFIGURE_ENV by bsd.pkg.mk if
GNU_CONFIGURE is defined, so simply set LIBS to the appropriate value.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.20 2001/06/11 06:34:24 jlam Exp $
d39 1
a39 1
PG_DIST_VERS=		7.1.2
@


1.20
log
@CPPFLAGS is now passed to MAKE_ENV and CONFIGURE_ENV by bsd.pkg.mk, so
adapt by moving CPPFLAGS settings to top-level, and removing explicit
inclusion of CPPFLAGS into MAKE_ENV and CONFIGURE_ENV.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.19 2001/06/11 02:05:08 jlam Exp $
a77 1
CONFIGURE_ENV+=		LIBS="${LIBS}"
@


1.19
log
@The buildlink include and lib directories are added to CFLAGS, CPPFLAGS,
CXXFLAGS, and LDFLAGS by the buildlink.mk files so remove the extra
definitions to add them from the package Makefiles.  As advised by the
bsd.buildlink.mk file, also ensure that the buildlink.mk files are
included prior to defining any package-specific CFLAGS/LDFLAGS to ensure
that the buildlink directories are at the head of the compiler search
paths.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.18 2001/05/29 23:28:05 jlam Exp $
a77 1
CONFIGURE_ENV+=		CPPFLAGS="${CPPFLAGS}"
@


1.18
log
@Update postgresql to 7.1.2.  Also update postgresql packages built from
postgresql sources:

	postgresql-client, postgresql-docs, postgresql-lib, postgresql-server,
	postgresql-plperl, postgresql-pltcl,
	odbc-postgresql, py-postgresql, tcl-postgresql, tk-postgresql

to 7.1.2 or to depend on postgresql-libs-7.1.2.  Changes from version 7.1.1:

	Fix PL/PgSQL SELECTs when returning no rows
	Fix for psql backslash core dump
	Referential integrity permission fix
	Optimizer fixes
	pg_dump cleanups
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.17 2001/05/25 14:56:34 jlam Exp $
a81 14
BUILDLINK_INCDIR=	${WRKDIR}/include
BUILDLINK_LIBDIR=	${WRKDIR}/lib

CPPFLAGS+=		-I${BUILDLINK_INCDIR}
CFLAGS+=		-I${BUILDLINK_INCDIR}
LDFLAGS+=		-L${BUILDLINK_LIBDIR}

# The following is a hack to force ${BUILDLINK_LIBDIR} to the front of the
# linker's library search path without having to patch a lot of Makefile.
# It works because the PostgreSQL Makefiles invoke the linker with $(CFLAGS)
# as well.
# 
CFLAGS+=		-L${BUILDLINK_LIBDIR}

a82 2
	${MKDIR} ${BUILDLINK_INCDIR}
	${MKDIR} ${BUILDLINK_LIBDIR}
@


1.17
log
@Add definitions for BUILDLINK_INCDIR and BUILDLINK_LIBDIR used by the
post-extract target.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.16 2001/05/24 08:54:27 jlam Exp $
d39 1
a39 1
PG_DIST_VERS=		7.1.1
@


1.16
log
@Standardize name of file to include for build-links to be "buildlink.mk".
Use BUILDLINK_INCDIR, BUILDLINK_LIBDIR for locations of linked headers
and libraries.  Create a variable BUILDLINK_TARGETS whose value is the
list of build-link targets to execute.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.15 2001/05/16 05:28:55 jlam Exp $
d82 3
d97 2
a98 1
	${MKDIR} ${BUILDLINK_INCDIR} ${BUILDLINK_LIBDIR}
@


1.15
log
@Adapt postgresql-client to use devel/readline/Makefile.readline instead
of the one in databases/postgresql.  Remove the Makefile.readline in
databases/postgresql as it's no longer used by any packages.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.14 2001/05/15 15:59:22 jlam Exp $
d82 8
a89 9
WRKINCDIR=		${WRKDIR}/include
WRKLIBDIR=		${WRKDIR}/lib
CPPFLAGS+=		-I${WRKINCDIR}
CFLAGS+=		-I${WRKINCDIR}
LDFLAGS+=		-L${WRKLIBDIR}

# The following is a hack to force ${WRKLIBDIR} to the front of the linker's
# library search path without having to patch a lot of Makefile.  It works
# because the PostgreSQL Makefiles invoke the linker with $(CFLAGS) as well.
d91 1
a91 1
CFLAGS+=		-L${WRKLIBDIR}
d94 1
a94 1
	${MKDIR} -p ${WRKINCDIR} ${WRKLIBDIR}
@


1.14
log
@Fix dependencies and post-extract target.  "Make build" in
databases/postgresql should now correctly trigger the full build and
installation of PostgreSQL.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.13 2001/05/14 15:45:08 jlam Exp $
d83 1
d86 7
d95 1
a95 1
	${MKDIR} -p ${WRKINCDIR}
@


1.13
log
@Document the package naming scheme for PostgreSQL packages.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.12 2001/05/14 14:52:36 jlam Exp $
d26 2
d88 10
a97 6
	${RM} -f ${WRKSRC}/src/Makefile.custom
	${CP} -f ${COMMON_FILESDIR}/Makefile.custom			\
		${WRKSRC}/src/Makefile.custom
	${RM} -f ${WRKSRC}/src/interfaces/libpq/GNUmakefile
	${CP} -f ${COMMON_FILESDIR}/GNUmakefile.libpq			\
		${WRKSRC}/src/interfaces/libpq/GNUmakefile
@


1.12
log
@Update postgresql to 7.1.1  Pkgsrc changes include splitting into:

	postgresql-lib
	postgresql-client
	postgresql-server
	postgresql-doc

with postgresql as a meta-package.  Major changes from version 7.1.1
include:

	Write-ahead Log (WAL) - To maintain database consistency in
case of an operating system crash, previous releases of PostgreSQL
have forced all data modifications to disk before each transaction
commit.  With WAL, only one log file must be flushed to disk, greatly
improving performance.  If you have been using -F in previous releases
to disable disk flushes, you may want to consider discontinuing its
use.

	TOAST - Previous releases had a compiled-in row length limit,
typically 8 - 32 kB.  This limit made storage of long text fields
difficult.  With TOAST, long rows of any length can be stored with
good performance.

	Outer Joins - We now support outer joins.  The UNION/NOT IN
workaround for outer joins is no longer required.  We use the SQL92
outer join syntax.

	Function Manager - The previous C function manager did not
handle NULLs properly, nor did it support 64-bit CPU's (Alpha).  The
new function manager does.  You can continue using your old custom
functions, but you may want to rewrite them in the future to use the
new function manager call interface.

	Complex Queries - A large number of complex queries that were
unsupported in previous releases now work.  Many combinations of
views, aggregates, UNION, LIMIT, cursors, subqueries, and inherited
tables now work properly. Inherited tables are now accessed by
default.  Subqueries in FROM are now supported.

Migration to 7.1.1

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.11 2001/05/04 01:05:19 jlam Exp $
d5 6
@


1.11
log
@Share a common distinfo file with the postgresql package.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.10 2001/04/10 13:08:05 jlam Exp $
d3 13
a15 18
# This file is included by the following packages:
#
#	postgresql
#	odbc-postgresql
#	tcl-postgresql
#	tk-postgresql

DISTNAME=		postgresql-${PG_VERS}
PG_VERS=		7.0.3
WRKSRC=			${WRKDIR}/${DISTNAME}/src
CATEGORIES=		databases
MASTER_SITES=		ftp://ftp.PostgreSQL.org/pub/v${PG_VERS}/ \
			ftp://ftp.de.postgresql.org/v${PG_VERS}/ \
			ftp://ch.postgresql.org/mirror/postgresql/pub/v${PG_VERS}/ \
			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/v${PG_VERS}/ \
			ftp://looking-glass.usask.ca/pub/postgresql/v${PG_VERS}/ \
			ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/v${PG_VERS}/ \
			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/v${PG_VERS}/
d18 5
a22 1
HOMEPAGE=		http://www.PostgreSQL.ORG/
d24 11
a34 1
BUILD_DEPENDS+=		autoconf-2.13:../../devel/autoconf
a37 7
#
# We don't USE_LIBTOOL for the shared libs since libtool doesn't seem to
# support inter-library dependencies across all platforms yet.

DISTINFO_FILE=		${.CURDIR}/../../databases/postgresql/distinfo
FILESDIR=		${.CURDIR}/../../databases/postgresql/files
PATCHDIR=		${.CURDIR}/../../databases/postgresql/patches
a40 4
CONFIGURE_ARGS+=	--with-template="${LOWER_OPSYS}"
CONFIGURE_ARGS+=	--with-setproctitle
CONFIGURE_ARGS+=	--enable-locale

d54 23
a76 2
# Pass CFLAGS from environment into the PostgreSQL build.
MAKE_ENV+=		COPT="${CFLAGS}"
d79 7
a85 4
	${CP} ${FILESDIR}/Makefile.custom ${WRKSRC}

pre-configure:
	cd ${WRKSRC} && ${LOCALBASE}/bin/autoreconf
@


1.10
log
@Note inclusion by odbc-postgresql
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.9 2001/03/27 03:19:49 hubertf Exp $
d33 1
@


1.9
log
@Change BUILD_DEPENDS semantics:
first component is now a package name+version/pattern, no more
executable/patchname/whatnot.

While there, introduce BUILD_USES_MSGFMT as shorthand to pull in
devel/gettext unless /usr/bin/msgfmt exists (i.e. on post-1.5 -current).

Patch by Alistair Crooks <agc@@netbsd.org>
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.8 2001/02/10 22:37:47 jlam Exp $
d6 1
@


1.8
log
@s/autoreconf/${LOCALBASE}/bin/autoreconf.  This was apparently missed in
the previous sweep for such changes (perhaps other Makefile.common files
also?).
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.7 2000/12/11 16:43:11 jlam Exp $
d24 1
a24 1
BUILD_DEPENDS+=		${LOCALBASE}/bin/autoreconf:../../devel/autoconf
@


1.7
log
@Cosmetic adjustments.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.6 2000/12/08 17:16:32 jlam Exp $
d24 1
a24 1
BUILD_DEPENDS+=		autoreconf:../../devel/autoconf
d61 1
a61 1
	cd ${WRKSRC} && autoreconf
@


1.6
log
@Note the packages that include this file so we note when other packages are
update when this one is updated.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.5 2000/12/07 08:29:00 mjl Exp $
d54 3
a61 2

.include "../../mk/bsd.pkg.mk"
@


1.5
log
@Update to 7.0.3.

Jdbc fixes (Peter)
Large object fix (Tom)
Fix lean in COPY WITH OIDS leak (Tom)
Fix backwards-index-scan (Tom)
Fix SELECT ... FOR UPDATE so it checks for duplicate keys (Hiroshi)
Add --enable-syslog to configure (Marc)
Fix abort transaction at backend exit in rare cases (Tom)
Fix for psql \l+ when multi-byte enabled (Tatsuo)
Allow PL/pgSQL to accept non ascii identifiers (Tatsuo)
Make vacuum always flush buffers (Tom)
Fix to allow cancel while waiting for a lock (Hiroshi)
Fix for memory aloocation problem in user authentication code (Tom)
Remove bogus use of int4out() (Tom)
Fixes for multiple subqueries in COALESCE or BETWEEN (Tom)
Fix for failure of triggers on heap open in certain cases (Jeroen van Vianen)
Fix for erroneous selectivity of not-equals (Tom)
Fix for erroneous use of strcmp() (Tom)
Fix for bug where storage manager accesses items beyond end of file (Tom)
Fix to include kernel errno message in all smgr elog messages (Tom)
Fix for '.' not in PATH at build time (SL Baur)
Fix for out-of-file-descriptors error (Tom)
Fix to make pg_dump dump 'iscachable' flag for functions (Tom)
Fix for subselect in targetlist of Append node (Tom)
Fix for mergejoin plans (Tom)
Fix TRUNCATE failure on relations with indexes (Tom)
Avoid database-wide restart on write error (Hiroshi)
Fix nodeMaterial to honor chgParam by recomputing its output (Tom)
Fix VACUUM problem with moving chain of update tuples when source and destination of a tuple lie on the same page (Tom)
Fix user.c CommandCounterIncrement (Tom)
Fix for AM/PM boundary problem in to_char() (Karel Zak)
Fix TIME aggregate handling (Tom)
Fix to_char() to avoid coredump on NULL input (Tom)
Buffer fix (Tom)
Fix for inserting/copying longer multibyte strings into char() data types (Tatsuo)
Fix for crash of backend, on abort (Tom)
@
text
@d1 7
a7 1
# $NetBSD: Makefile.common,v 1.4 2000/07/14 04:44:11 jlam Exp $
@


1.4
log
@Update postgresql to 7.0.2.  Relevant changes from 7.0:

* Enhance rc.d/pgsql.sh script to accept start/stop/restart.
* Add fixes for alpha from Kevin P. Neal <kpn@@neutralgood.org> in PR#10543.

  XXX Includes a patch which removes inlining of the alpha's TAS function.
  XXX This is apparently some code-gen bug in GCC for alpha.

* Fix many CLUSTER failures (Tom)
* Allow ALTER TABLE RENAME works on indexes (Tom)
* Fix plpgsql to handle datetime->timestamp and timespan->interval (Bruce)
* New configure --with-setproctitle switch to use setproctitle() (Marc, Bruce)
* Fix the off by one errors in ResultSet from 6.5.3, and more.
* jdbc ResultSet fixes (Joseph Shraibman)
* optimizer tunings (Tom)
* Fix create user for pgaccess
* Fix for UNLISTEN failure
* Reduce COPY IN lock level (Tom)
* Change libpqeasy to use PQconnectdb() style parameters (Bruce)
* Fix pg_dump to handle OID indexes (Tom)
* Fix small memory leak (Tom)
* Solaris fix for createdb/dropdb (Tatsuo)
* Fix for non-blocking connections (Alfred Perlstein)
* Fix improper recovery after RENAME TABLE failures (Tom)
* Copy pg_ident.conf.sample into /lib directory in install (Bruce)
* Add SJIS UDC (NEC selection IBM kanji) support (Eiji Tokuya)
* Fix too long syslog message (Tatsuo)
* Fix problem with quoted indexes that are too long (Tom)
* JDBC ResultSet.getTimestamp() fix (Gregory Krasnow & Floyd Marinescu)
* ecpg changes (Michael)
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.3 2000/05/24 09:11:24 rh Exp $
d4 1
a4 1
PG_VERS=		7.0.2
@


1.3
log
@Fix MASTER_SITES
Add some additional mirrors
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.2 2000/05/20 19:32:18 jlam Exp $
d4 1
a4 1
PG_VERS=		7.0
d7 7
a13 7
MASTER_SITES=		ftp://ftp.PostgreSQL.org/pub/v7.0/ \
			ftp://ftp.de.postgresql.org/v7.0/ \
			ftp://ch.postgresql.org/mirror/postgresql/pub/v7.0/ \
			ftp://gd.tuwien.ac.at/db/www.postgresql.org/pub/v7.0/ \
			ftp://looking-glass.usask.ca/pub/postgresql/v7.0/ \
			ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/v7.0/ \
			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/v7.0/
d18 1
a18 1
BUILD_DEPENDS+=		${LOCALBASE}/bin/autoreconf:../../devel/autoconf
d22 3
d31 3
a33 2
CONFIGURE_ARGS+=	--with-template="${LOWER_OPSYS}" \
			--enable-locale
d52 1
a52 1
	cd ${WRKSRC}; ${LOCALBASE}/bin/autoreconf
@


1.2
log
@Update postgresql to 7.0.  Also closes PR#8616.  Changes from 6.5.3:

   A HUGE number of bug/performance fixes and minor enhancements.

   Foreign Keys
          Foreign keys are now implemented, with the exception of PARTIAL
          MATCH foreign keys. Many users have been asking for this
          feature, and we are pleased to offer it.

   Optimizer Overhaul
          Continuing on work started a year ago, the optimizer has been
          overhauled, allowing improved query execution and better
          performance with less memory usage.

   Updated psql
          psql, our interactive terminal monitor, has been updated with a
          variety of new features. See the psql manual page for details.

   Upcoming Features
          In 7.1 or 7.2, we plan to have outer joins, storage for very
          long rows, and a write-ahead logging system.

   A dump/restore using pg_dump is required for those wishing to migrate
   data from any previous release. For those upgrading from 6.5.*, you
   can use pg_upgrade to upgrade to this release.
@
text
@d1 1
a1 1
# $NetBSD: Makefile.common,v 1.1 2000/03/18 17:43:16 jlam Exp $
d7 7
a13 3
MASTER_SITES=		ftp://ftp.PostgreSQL.org/pub/ \
			ftp://ftp.sunsite.auc.dk/mirrors/www.postgresql.org/pub/ \
			ftp://ftp.jaist.ac.jp/pub/dbms/postgres95/
@


1.1
log
@Change structure of postgresql package.  Shared library build is now
unlibtoolized.  Things now install into ${PREFIX} instead of
${PREFIX}/${PGSQL_USER} to match hier(7) expectations.  The Tcl and Tk
interfaces are now split out into separate packages.

This closes the following PRs: 7384, 8747, 8789, 9272, 9461.
@
text
@d1 1
a1 1
# $NetBSD$
d3 2
a4 1
DISTNAME=		postgresql-6.5.3
d16 2
a17 2
USE_GMAKE=		yes
GNU_CONFIGURE=		yes
d27 13
d41 1
a41 5
	@@${CP} ${FILESDIR}/Makefile.custom ${WRKSRC}
	@@${LN} -sf bsd.c ${WRKSRC}/backend/port/dynloader/netbsd.c
	@@${LN} -sf bsd.h ${WRKSRC}/backend/port/dynloader/netbsd.h
	@@${LN} -sf bsd.h ${WRKSRC}/include/port/netbsd.h
	@@${LN} -sf Makefile.bsd ${WRKSRC}/makefiles/Makefile.netbsd
@