Change PostgreSQL default version to 8.1 and bump revision of all

packages which have it active by default.

31 files changed, 62 insertions, 47 deletions

diff --git a/databases/gtksql/Makefile b/databases/gtksql/Makefile
index 273d3de446f..c659b16e9c7 100644
--- a/databases/gtksql/Makefile
+++ b/databases/gtksql/Makefile
@@ -1,8 +1,8 @@
-# $NetBSD: Makefile,v 1.39 2006/10/04 20:53:45 wiz Exp $
+# $NetBSD: Makefile,v 1.40 2006/12/28 12:12:57 joerg Exp $
 #
 
 DISTNAME=		gtksql-0.3
-PKGREVISION=		6
+PKGREVISION=		7
 CATEGORIES=		databases
 MASTER_SITES=		http://membres.lycos.fr/bbrox/GtkSQL/ \
 			${MASTER_SITE_SUNSITE:=X11/gtkbuffet/apps/gtksql/} \
diff --git a/databases/libgda-postgres/Makefile b/databases/libgda-postgres/Makefile
index 6bf6d43b124..5942a6fc97e 100644
--- a/databases/libgda-postgres/Makefile
+++ b/databases/libgda-postgres/Makefile
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.11 2006/12/05 10:22:47 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2006/12/28 12:12:57 joerg Exp $
 #
 
 LIBGDA_PROVIDER=	postgres
+PKGREVISION=		1
 
 .include "../../databases/libgda/Makefile.common"
 
diff --git a/databases/libpqxx/Makefile b/databases/libpqxx/Makefile
index 9d6a2d7ddb6..6503594a063 100644
--- a/databases/libpqxx/Makefile
+++ b/databases/libpqxx/Makefile
@@ -1,9 +1,10 @@
-# $NetBSD: Makefile,v 1.18 2006/08/23 11:45:26 ghen Exp $
+# $NetBSD: Makefile,v 1.19 2006/12/28 12:12:57 joerg Exp $
 #
 
 .include "../../databases/libpqxx/Makefile.common"
 
 COMMENT=		C++ interface to postgresql-lib
+PKGREVISION=		1
 
 NOT_FOR_PLATFORM=	NetBSD-*-pc532
 
diff --git a/databases/p5-DBD-postgresql/Makefile b/databases/p5-DBD-postgresql/Makefile
index e983c234699..b082a161665 100644
--- a/databases/p5-DBD-postgresql/Makefile
+++ b/databases/p5-DBD-postgresql/Makefile
@@ -1,11 +1,11 @@
-# $NetBSD: Makefile,v 1.37 2006/04/23 14:22:19 hiramatsu Exp $
+# $NetBSD: Makefile,v 1.38 2006/12/28 12:12:57 joerg Exp $
 #
 
 VER=		1.48
 DISTNAME=	DBD-Pg-${VER}
 PKGNAME=	p5-DBD-postgresql-${VER}
 SVR4_PKGNAME=	p5dpo
-PKGREVISION=	2
+PKGREVISION=	3
 CATEGORIES=	databases perl5
 MASTER_SITES=	${MASTER_SITE_PERL_CPAN:=DBD/}
 
diff --git a/databases/p5-postgresql/Makefile b/databases/p5-postgresql/Makefile
index bc7491c66b2..97a686dea2d 100644
--- a/databases/p5-postgresql/Makefile
+++ b/databases/p5-postgresql/Makefile
@@ -1,8 +1,8 @@
-# $NetBSD: Makefile,v 1.20 2006/03/04 21:29:10 jlam Exp $
+# $NetBSD: Makefile,v 1.21 2006/12/28 12:12:57 joerg Exp $
 
 DISTNAME=	pgsql_perl5-1.9.0
 PKGNAME=	p5-postgresql-1.9.0
-PKGREVISION=	5
+PKGREVISION=	6
 SVR4_PKGNAME=	p5pgs
 CATEGORIES=	databases devel perl5
 MASTER_SITES=	${MASTER_SITE_PERL_CPAN:=Pg/}
diff --git a/databases/pgadmin3/Makefile b/databases/pgadmin3/Makefile
index 6d25484fb49..6daf4804dcc 100644
--- a/databases/pgadmin3/Makefile
+++ b/databases/pgadmin3/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.3 2006/07/22 04:46:15 rillig Exp $
+# $NetBSD: Makefile,v 1.4 2006/12/28 12:12:57 joerg Exp $
 
 DISTNAME=	pgadmin3-1.4.2
-PKGREVISION=	1
+PKGREVISION=	2
 CATEGORIES=	databases
 MASTER_SITES=	${PGSQL_MIRRORS:=pgadmin3/release/v1.4.2/src/}
 
diff --git a/databases/pgtcl/Makefile b/databases/pgtcl/Makefile
index b51e028b616..bc5a80b711a 100644
--- a/databases/pgtcl/Makefile
+++ b/databases/pgtcl/Makefile
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile,v 1.2 2006/02/05 23:08:33 joerg Exp $
+# $NetBSD: Makefile,v 1.3 2006/12/28 12:12:57 joerg Exp $
 #
 
 DISTNAME=	pgtcl1.5
 PKGNAME=	pgtcl-1.5
-PKGREVISION=	1
+PKGREVISION=	2
 CATEGORIES=	databases tcl
 CATEGORIES=	databases
 MASTER_SITES=	ftp://gborg.postgresql.org/pub/pgtcl/stable/
diff --git a/databases/pgtclng/Makefile b/databases/pgtclng/Makefile
index a1db465ca31..b3d8a7a39e9 100644
--- a/databases/pgtclng/Makefile
+++ b/databases/pgtclng/Makefile
@@ -1,10 +1,10 @@
-# $NetBSD: Makefile,v 1.2 2006/12/01 21:11:48 rillig Exp $
+# $NetBSD: Makefile,v 1.3 2006/12/28 12:12:57 joerg Exp $
 #
 
 VER=		1.5.3
 DISTNAME=	pgtcl${VER}
 PKGNAME=	pgtclng-${VER}
-PKGREVISION=	1
+PKGREVISION=	2
 CATEGORIES=	databases tcl
 MASTER_SITES=	http://pgfoundry.org/frs/download.php/1075/
 
diff --git a/databases/php-pdo_pgsql/Makefile b/databases/php-pdo_pgsql/Makefile
index e742eaaab1e..b4095100a46 100644
--- a/databases/php-pdo_pgsql/Makefile
+++ b/databases/php-pdo_pgsql/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.4 2006/06/02 18:27:55 joerg Exp $
+# $NetBSD: Makefile,v 1.5 2006/12/28 12:12:58 joerg Exp $
 
 PDO_DRIVER=		pgsql
 PDO_COMMENT=		PostgreSQL
 PDO_VERSION=		1.0.1
+PKGREVISION=		1
 
 .include "../../databases/php-pdo/module.mk"
 
diff --git a/databases/php-pgsql/Makefile b/databases/php-pgsql/Makefile
index f0568abc1f9..d249915674c 100644
--- a/databases/php-pgsql/Makefile
+++ b/databases/php-pgsql/Makefile
@@ -1,6 +1,7 @@
-# $NetBSD: Makefile,v 1.8 2006/06/04 16:26:53 joerg Exp $
+# $NetBSD: Makefile,v 1.9 2006/12/28 12:12:58 joerg Exp $
 
 MODNAME=		pgsql
+PKGREVISION=		1
 CATEGORIES+=		databases
 COMMENT=		PHP extension for PostgreSQL databases
 
diff --git a/databases/py-PgSQL/Makefile b/databases/py-PgSQL/Makefile
index 73427549821..b3892cdd73a 100644
--- a/databases/py-PgSQL/Makefile
+++ b/databases/py-PgSQL/Makefile
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile,v 1.12 2006/06/02 23:31:33 joerg Exp $
+# $NetBSD: Makefile,v 1.13 2006/12/28 12:12:58 joerg Exp $
 #
 
 DISTNAME=	pyPgSQL-2.4
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME:S/py//}
-PKGREVISION=	3
+PKGREVISION=	4
 CATEGORIES=	databases python
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE:=pypgsql/}
 
diff --git a/databases/py-postgresql/Makefile b/databases/py-postgresql/Makefile
index a0846991eb9..81ac782469d 100644
--- a/databases/py-postgresql/Makefile
+++ b/databases/py-postgresql/Makefile
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.49 2006/09/09 02:41:56 obache Exp $
+# $NetBSD: Makefile,v 1.50 2006/12/28 12:12:58 joerg Exp $
 
 DISTNAME=		PyGreSQL-3.8.1
 PKGNAME=		${PYPKGPREFIX}-postgresql-3.8.1
+PKGREVISION=		1
 CATEGORIES=		databases python
 MASTER_SITES=		ftp://ftp.druid.net/pub/distrib/
 EXTRACT_SUFX=		.tgz
diff --git a/databases/py-psycopg/Makefile b/databases/py-psycopg/Makefile
index 3c9833b5130..779ae4f0340 100644
--- a/databases/py-psycopg/Makefile
+++ b/databases/py-psycopg/Makefile
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile,v 1.26 2006/10/14 08:01:39 wiz Exp $
+# $NetBSD: Makefile,v 1.27 2006/12/28 12:12:58 joerg Exp $
 #
 
 DISTNAME=	psycopg-1.1.21
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
-PKGREVISION=	1
+PKGREVISION=	2
 CATEGORIES=	databases python
 MASTER_SITES=	http://initd.org/pub/software/psycopg/
 
diff --git a/databases/py-psycopg2/Makefile b/databases/py-psycopg2/Makefile
index a223cf7f108..02be03f199e 100644
--- a/databases/py-psycopg2/Makefile
+++ b/databases/py-psycopg2/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.3 2006/10/09 12:52:34 joerg Exp $
+# $NetBSD: Makefile,v 1.4 2006/12/28 12:12:58 joerg Exp $
 #
 
 DISTNAME=	psycopg2-2.0.5.1
 PKGNAME=	${PYPKGPREFIX}-${DISTNAME}
+PKGREVISION=	1
 CATEGORIES=	databases python
 MASTER_SITES=	http://initd.org/pub/software/psycopg/
 
diff --git a/databases/ruby-postgresql/Makefile b/databases/ruby-postgresql/Makefile
index 9b0144904b3..6004d2b7425 100644
--- a/databases/ruby-postgresql/Makefile
+++ b/databases/ruby-postgresql/Makefile
@@ -1,8 +1,8 @@
-# $NetBSD: Makefile,v 1.29 2006/03/04 21:29:11 jlam Exp $
+# $NetBSD: Makefile,v 1.30 2006/12/28 12:12:58 joerg Exp $
 
 DISTNAME=		ruby-postgres-${VERSION}
 PKGNAME=		${RUBY_PKGPREFIX}-postgresql-${VERSION}
-PKGREVISION=		7
+PKGREVISION=		8
 CATEGORIES=		databases ruby
 MASTER_SITES=		http://raa.ruby-lang.org/cache/postgres/ \
 			http://ruby.scripting.ca/postgres/archive/ \
diff --git a/databases/ruby-vapor/Makefile b/databases/ruby-vapor/Makefile
index 7faea7c9d6b..e3ec7f6689f 100644
--- a/databases/ruby-vapor/Makefile
+++ b/databases/ruby-vapor/Makefile
@@ -1,8 +1,8 @@
-# $NetBSD: Makefile,v 1.16 2006/03/04 21:29:11 jlam Exp $
+# $NetBSD: Makefile,v 1.17 2006/12/28 12:12:58 joerg Exp $
 
 DISTNAME=	vapor-0.81
 PKGNAME=	${RUBY_PKGPREFIX}-${DISTNAME}
-PKGREVISION=	3
+PKGREVISION=	4
 CATEGORIES=	databases ruby
 MASTER_SITES=	http://rubyforge.org/frs/download.php/215/
 
diff --git a/databases/slony1/Makefile b/databases/slony1/Makefile
index b3cef6a090d..ff16ad9ec3e 100644
--- a/databases/slony1/Makefile
+++ b/databases/slony1/Makefile
@@ -1,6 +1,7 @@
-# $NetBSD: Makefile,v 1.4 2006/10/18 18:53:03 adam Exp $
+# $NetBSD: Makefile,v 1.5 2006/12/28 12:12:58 joerg Exp $
 
 DISTNAME=	slony1-1.2.0
+PKGREVISION=	1
 CATEGORIES=	databases
 MASTER_SITES=	http://pgfoundry.org/frs/download.php/1136/
 EXTRACT_SUFX=	.tar.bz2
diff --git a/geography/gdal-lib/Makefile b/geography/gdal-lib/Makefile
index 98ce6bdb78d..f8aac4e86b7 100644
--- a/geography/gdal-lib/Makefile
+++ b/geography/gdal-lib/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.5 2006/10/24 09:00:02 rillig Exp $
+# $NetBSD: Makefile,v 1.6 2006/12/28 12:12:58 joerg Exp $
 #
 
 DISTNAME=		gdal-1.3.1
 PKGNAME=		gdal-lib-1.3.1
+PKGREVISION=		1
 CATEGORIES=		geography
 MASTER_SITES=		http://www.gdal.org/dl/
 
diff --git a/mail/perdition-postgresql/Makefile b/mail/perdition-postgresql/Makefile
index 2aaefdaf09b..2bdbb925bd8 100644
--- a/mail/perdition-postgresql/Makefile
+++ b/mail/perdition-postgresql/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.2 2006/02/05 23:09:57 joerg Exp $
+# $NetBSD: Makefile,v 1.3 2006/12/28 12:12:58 joerg Exp $
 #
 
-PKGREVISION=		1
+PKGREVISION=		2
 
 PERDITION_COMMENT=	PostgreSQL user database module
 PERDITION_PKGNAME=	postgresql
diff --git a/mk/pgsql.buildlink3.mk b/mk/pgsql.buildlink3.mk
index 7e363d81b12..f462bbb84d0 100644
--- a/mk/pgsql.buildlink3.mk
+++ b/mk/pgsql.buildlink3.mk
@@ -1,4 +1,4 @@
-# $NetBSD: pgsql.buildlink3.mk,v 1.20 2006/12/27 15:57:36 joerg Exp $
+# $NetBSD: pgsql.buildlink3.mk,v 1.21 2006/12/28 12:12:57 joerg Exp $
 #
 # User-settable variables:
 #
@@ -20,7 +20,7 @@ PGVERSION_MK=	defined
 
 .include "../../mk/bsd.prefs.mk"
 
-PGSQL_VERSION_DEFAULT?=		80
+PGSQL_VERSION_DEFAULT?=		81
 PGSQL_VERSIONS_ACCEPTED?=	82 81 80
 
 # transform the list into individual variables
diff --git a/net/mydns-pgsql/Makefile b/net/mydns-pgsql/Makefile
index 2819281ec43..0af1a72ffaa 100644
--- a/net/mydns-pgsql/Makefile
+++ b/net/mydns-pgsql/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.7 2006/06/07 12:54:48 joerg Exp $
+# $NetBSD: Makefile,v 1.8 2006/12/28 12:12:58 joerg Exp $
 
 PKGNAME=		${DISTNAME:S/-/-pgsql-/}
-PKGREVISION=		2
+PKGREVISION=		3
 COMMENT=		PostgreSQL-based DNS server
 
 CONFLICTS=		mydns-mysql-[0-9]*
diff --git a/net/nagios-plugin-pgsql/Makefile b/net/nagios-plugin-pgsql/Makefile
index 60bed12dc12..5f86d08d813 100644
--- a/net/nagios-plugin-pgsql/Makefile
+++ b/net/nagios-plugin-pgsql/Makefile
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.3 2006/10/23 07:17:40 seb Exp $
+# $NetBSD: Makefile,v 1.4 2006/12/28 12:12:58 joerg Exp $
 #
 
 PKGNAME=	nagios-plugin-pgsql-${PLUGINSVERSION}
+PKGREVISION=	1
 CATEGORIES=   	net sysutils databases
 
 MAINTAINER=     pkgsrc-users@NetBSD.org
diff --git a/net/netsaint-plugins/Makefile b/net/netsaint-plugins/Makefile
index 35eef7b5142..85f5f4d166b 100644
--- a/net/netsaint-plugins/Makefile
+++ b/net/netsaint-plugins/Makefile
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile,v 1.27 2006/03/04 21:30:21 jlam Exp $
+# $NetBSD: Makefile,v 1.28 2006/12/28 12:12:58 joerg Exp $
 #
 
 DISTNAME=		netsaint-plugins-1.2.9-4
 PKGNAME=		netsaint-plugins-1.2.9.4
-PKGREVISION=		10
+PKGREVISION=		11
 CATEGORIES=		net
 MASTER_SITES=		${MASTER_SITE_SOURCEFORGE:=netsaintplug/}
 
diff --git a/net/powerdns-pgsql/Makefile b/net/powerdns-pgsql/Makefile
index 5d6708b5155..fed88403af2 100644
--- a/net/powerdns-pgsql/Makefile
+++ b/net/powerdns-pgsql/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.1.1.1 2006/08/13 09:36:06 ghen Exp $
+# $NetBSD: Makefile,v 1.2 2006/12/28 12:12:58 joerg Exp $
 
 .include "../../net/powerdns/Makefile.backend"
 
 PKGNAME=		${DISTNAME:S/pdns/powerdns-pgsql/}
+PKGREVISION=		1
 COMMENT=		PostgreSQL backend module for PowerDNS
 
 CONFIGURE_ARGS+=	--with-dynmodules="gpgsql"
diff --git a/net/snort-pgsql/Makefile b/net/snort-pgsql/Makefile
index 9c27854bd6a..88461c932c8 100644
--- a/net/snort-pgsql/Makefile
+++ b/net/snort-pgsql/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.21 2006/04/18 22:39:32 adrianp Exp $
+# $NetBSD: Makefile,v 1.22 2006/12/28 12:12:58 joerg Exp $
 
 .include "../../net/snort/Makefile.common"
 
 PKGNAME=	${DISTNAME:S/-/-pgsql-/}
+PKGREVISION=	1
 
 COMMENT=	Network Intrusion Detection System (with PostgreSQL support)
 
diff --git a/www/ap-auth-pgsql/Makefile b/www/ap-auth-pgsql/Makefile
index daaaf1071be..193ddcdc6d2 100644
--- a/www/ap-auth-pgsql/Makefile
+++ b/www/ap-auth-pgsql/Makefile
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.9 2006/06/02 18:27:58 joerg Exp $
+# $NetBSD: Makefile,v 1.10 2006/12/28 12:12:58 joerg Exp $
 
 DISTNAME=	mod_auth_pgsql-0.9.12
 PKGNAME=	ap13-auth-pgsql-0.9.12
+PKGREVISION=	1
 CATEGORIES=	www databases
 MASTER_SITES=	http://www.giuseppetanzilli.it/mod_auth_pgsql/dist/
 
diff --git a/www/ap-auth-postgresql/Makefile b/www/ap-auth-postgresql/Makefile
index b5e93a6b435..9b956e22871 100644
--- a/www/ap-auth-postgresql/Makefile
+++ b/www/ap-auth-postgresql/Makefile
@@ -1,7 +1,8 @@
-# $NetBSD: Makefile,v 1.28 2006/06/02 18:27:58 joerg Exp $
+# $NetBSD: Makefile,v 1.29 2006/12/28 12:12:59 joerg Exp $
 
 DISTNAME=	AuthPG-1.4
 PKGNAME=	ap13-auth-postgresql-1.4
+PKGREVISON=	1
 CATEGORIES=	www databases
 MASTER_SITES=	${MASTER_SITE_SOURCEFORGE:=authpg/}
 
diff --git a/www/ap2-auth-pgsql/Makefile b/www/ap2-auth-pgsql/Makefile
index 2da9ff3020a..9aaa0ce1793 100644
--- a/www/ap2-auth-pgsql/Makefile
+++ b/www/ap2-auth-pgsql/Makefile
@@ -1,8 +1,8 @@
-# $NetBSD: Makefile,v 1.16 2006/12/08 23:34:10 xtraeme Exp $
+# $NetBSD: Makefile,v 1.17 2006/12/28 12:12:59 joerg Exp $
 
 DISTNAME=		mod_auth_pgsql-2.0.3
 PKGNAME=		ap2-auth-pgsql-2.0.3
-PKGREVISION=		3
+PKGREVISION=		4
 CATEGORIES=		www databases
 MASTER_SITES=		http://www.giuseppetanzilli.it/mod_auth_pgsql2/dist/
 
diff --git a/www/sope/Makefile b/www/sope/Makefile
index 04dbb1929a2..5889ee7e11e 100644
--- a/www/sope/Makefile
+++ b/www/sope/Makefile
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile,v 1.10 2006/05/31 18:22:26 ghen Exp $
+# $NetBSD: Makefile,v 1.11 2006/12/28 12:12:59 joerg Exp $
 #
 
 DISTNAME=		sope-4.5.4-nevermind-r878
 PKGNAME=		sope-4.5.4
-PKGREVISION=		4
+PKGREVISION=		5
 CATEGORIES=		www gnustep
 MASTER_SITES=		ftp://ftp.opengroupware.org/nightly/sources/releases/ \
 			http://download.opengroupware.org/nightly/sources/releases/
diff --git a/x11/qt3-pgsql/Makefile b/x11/qt3-pgsql/Makefile
index 1e570d69c42..22386cf714d 100644
--- a/x11/qt3-pgsql/Makefile
+++ b/x11/qt3-pgsql/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.1.1.1 2006/06/14 15:50:45 adam Exp $
+# $NetBSD: Makefile,v 1.2 2006/12/28 12:12:59 joerg Exp $
 
 .include "../../x11/qt3-libs/Makefile.common"
 
 PKGNAME=	qt3-psql-${QTVERSION}
+PKGREVISION=	1
 COMMENT=	QT postgresql driver
 
 CONFIGURE_ARGS+=	-I${QTDIR}/include \
diff --git a/x11/qt4-pgsql/Makefile b/x11/qt4-pgsql/Makefile
index 927f6e445ca..5b5f65e5b2f 100644
--- a/x11/qt4-pgsql/Makefile
+++ b/x11/qt4-pgsql/Makefile
@@ -1,8 +1,9 @@
-# $NetBSD: Makefile,v 1.1.1.1 2006/06/14 15:51:38 adam Exp $
+# $NetBSD: Makefile,v 1.2 2006/12/28 12:12:59 joerg Exp $
 
 .include "../../x11/qt4-libs/Makefile.common"
 
 PKGNAME=	qt4-psql-${QTVERSION}
+PKGREVISION=	1
 COMMENT=	QT postgresql driver
 
 CONFIGURE_ARGS+=	-I${QTDIR}/include