This is a port of the client odbc support from the postgresql-7.2

distribution, that used to be apart of the postgresql7 port.

PR:		ports/34857
Submitted by:	Palle Girgensohn <girgen@partitur.se>

5 files changed, 66 insertions, 0 deletions

diff --git a/databases/Makefile b/databases/Makefile
index cbfbe52af1cf..606d8af029a0 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -92,6 +92,7 @@
     SUBDIR += phpmyadmin
     SUBDIR += phppgadmin
     SUBDIR += postgresql-jdbc
+    SUBDIR += postgresql-odbc
     SUBDIR += postgresql-plruby
     SUBDIR += postgresql7
     SUBDIR += pxtools
diff --git a/databases/postgresql-odbc/Makefile b/databases/postgresql-odbc/Makefile
new file mode 100644
index 000000000000..f258f181d5b7
--- /dev/null
+++ b/databases/postgresql-odbc/Makefile
@@ -0,0 +1,46 @@
+# New ports collection makefile for:	PostgreSQL JDBC
+# Date created:		January 14, 2002
+# Whom:			Palle Girgensohn <girgen@partitur.se>
+#
+# $FreeBSD$
+#
+
+PORTNAME=	postgresql-odbc
+PORTVERSION=	7.2
+CATEGORIES=	databases
+
+MAINTAINER=	girgen@partitur.se
+
+POSTGRESQL_SUBPORT=YES
+.include <${.CURDIR}/../postgresql7/Makefile>
+
+CONFIGURE_ARGS= --with-libdir=${LOCALBASE}/lib \
+		--with-includes=${LOCALBASE}/include
+LDFLAGS=	-L${LOCALBASE}/lib
+MAKE_ARGS=	LDFLAGS=${LDFLAGS}
+
+# PostgreSQL ODBC support needs an ODBC driver manager to be
+# installed, and it supports both iODBC and unixODBC.  The following
+# variable may be set at built-time to either "iodbc" or "unixodbc",
+# with the former being the default:
+DRIVER_MANAGER?=	iodbc
+
+# Note that there is a potential conflict between unixODBC's and
+# postgres' libodbcpsql.so. unixODBC installs versions `1' & `2' of
+# the named lib, while postgres installs version `0'. The postgres
+# folks say their is the best, so you might be better off removing
+# the others?
+.if ${DRIVER_MANAGER} == "unixodbc"
+CONFIGURE_ARGS+=	--with-unixodbc
+LIB_DEPENDS+=		odbc.1:${PORTSDIR}/databases/unixODBC
+PLIST_SUB+=UNIXODBC="" IODBC="@comment "
+.else	# assume we're using iodbc
+LIB_DEPENDS+=		iodbc.3:${PORTSDIR}/databases/libiodbc
+CONFIGURE_ARGS+=	--with-iodbc --with-odbcinst=${LOCALBASE}/etc/libiodbc
+PLIST_SUB+=UNIXODBC="@comment " IODBC=""
+.endif
+
+MAKEFILE=	GNUmakefile
+MAKE_ARGS+=	-C src/interfaces/odbc
+
+.include <bsd.port.mk>
diff --git a/databases/postgresql-odbc/pkg-comment b/databases/postgresql-odbc/pkg-comment
new file mode 100644
index 000000000000..8b378092bdac
--- /dev/null
+++ b/databases/postgresql-odbc/pkg-comment
@@ -0,0 +1 @@
+PostgreSQL ODBC client support
diff --git a/databases/postgresql-odbc/pkg-descr b/databases/postgresql-odbc/pkg-descr
new file mode 100644
index 000000000000..1c37fe2013ca
--- /dev/null
+++ b/databases/postgresql-odbc/pkg-descr
@@ -0,0 +1,9 @@
+Support connecting to a postgresql database from a unix client
+application using ODBC.
+
+Note: You do not need this port installed on unix if you want to use
+ODBC to connect a Windows machine with PostgreSQL.
+
+This software is part of the standard PostgreSQL distribution.
+
+WWW: http://www.postgresql.org/
diff --git a/databases/postgresql-odbc/pkg-plist b/databases/postgresql-odbc/pkg-plist
new file mode 100644
index 000000000000..d04b78a6bf2a
--- /dev/null
+++ b/databases/postgresql-odbc/pkg-plist
@@ -0,0 +1,9 @@
+%%IODBC%%lib/libpsqlodbc.so
+%%IODBC%%lib/libpsqlodbc.a
+%%IODBC%%lib/libpsqlodbc.so.0
+%%UNIXODBC%%lib/libodbcpsql.so
+%%UNIXODBC%%lib/libodbcpsql.a
+%%UNIXODBC%%lib/libodbcpsql.so.0
+share/postgresql/odbc.sql
+share/postgresql/odbc-drop.sql
+@unexec rmdir %D/share/postgresql 2>/dev/null || true