From owner-freebsd-ports-bugs@FreeBSD.ORG Sun Dec 26 22:10:09 2010 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 71D17106566C for ; Sun, 26 Dec 2010 22:10:09 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 4632A8FC12 for ; Sun, 26 Dec 2010 22:10:09 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id oBQMA91x086321 for ; Sun, 26 Dec 2010 22:10:09 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id oBQMA9eZ086320; Sun, 26 Dec 2010 22:10:09 GMT (envelope-from gnats) Date: Sun, 26 Dec 2010 22:10:09 GMT Message-Id: <201012262210.oBQMA9eZ086320@freefall.freebsd.org> To: freebsd-ports-bugs@FreeBSD.org From: Berend de Boer Cc: Subject: Re: ports/144993: databases/postgresql-odbc: contents of numeric fields returned as 0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Berend de Boer List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 26 Dec 2010 22:10:09 -0000 The following reply was made to PR ports/144993; it has been noted by GNATS. From: Berend de Boer To: bug-followup@FreeBSD.org Cc: Subject: Re: ports/144993: databases/postgresql-odbc: contents of numeric fields returned as 0 Date: Mon, 27 Dec 2010 10:49:56 +1300 Hi FreeBSD, As suggested have used 08.04.0200 and that appears to work fine as well. Here the patch to upgrade the port to this version. As it appears the maintainer has no time, I'm happy to become maintainer as I probably need this working correctly for a few years. diff -urN postgresql-odbc.orig/Makefile postgresql-odbc/Makefile --- postgresql-odbc.orig/Makefile 2010-11-10 23:19:44.000000000 +1300 +++ postgresql-odbc/Makefile 2010-12-27 10:30:51.000000000 +1300 @@ -32,7 +32,7 @@ # this is considered to be a part of the `postgresql' port. PORTNAME= postgresql -PORTVERSION= 08.04.0100 +PORTVERSION= 08.04.0200 PORTREVISION= 0 CATEGORIES= databases MASTER_SITES= ${MASTER_SITE_PGSQL} @@ -45,12 +45,10 @@ MAINTAINER= ports@FreeBSD.org COMMENT= PostgreSQL ODBC driver -BUILD_DEPENDS= pg_config:${PORTSDIR}/databases/postgresql83-client +BUILD_DEPENDS= pg_config:${PORTSDIR}/databases/postgresql84-client GNU_CONFIGURE= YES -IGNORE= does not work properly (see ports/144993) - .if !defined(WITH_IODBC) WITH_UNIXODBC= yes .endif @@ -71,6 +69,7 @@ DATADIR_1= ${DATADIR}/odbc DOCSDIR_1= ${DOCSDIR}/odbc post-install: + ${LN} ${PREFIX}/lib/libpsqlodbcw.so.0.0 ${PREFIX}/lib/psqlodbcw.so .if !defined(NOPORTDATA) @${MKDIR} ${DATADIR_1} ${INSTALL_DATA} ${WRKSRC}/*.sql ${DATADIR_1} diff -urN postgresql-odbc.orig/distinfo postgresql-odbc/distinfo --- postgresql-odbc.orig/distinfo 2009-11-05 10:11:51.000000000 +1300 +++ postgresql-odbc/distinfo 2010-12-27 09:59:52.000000000 +1300 @@ -1,3 +1,2 @@ -MD5 (postgresql/psqlodbc-08.04.0100.tar.gz) = 2328c3e97e6a376620a5d317137515ff -SHA256 (postgresql/psqlodbc-08.04.0100.tar.gz) = 57bb143d5d20804c5ce96214227e6e65dc16520efce7ac25ddb7cc4c8aa0db0a -SIZE (postgresql/psqlodbc-08.04.0100.tar.gz) = 736714 +SHA256 (postgresql/psqlodbc-08.04.0200.tar.gz) = 6e745e9083d605b1cdeaacdd3bea8f83246da302f2df7ebbd72adca06460cb3f +SIZE (postgresql/psqlodbc-08.04.0200.tar.gz) = 725393 diff -urN postgresql-odbc.orig/files/patch-odbcapi30.c postgresql-odbc/files/patch-odbcapi30.c --- postgresql-odbc.orig/files/patch-odbcapi30.c 2009-01-27 18:13:09.000000000 +1300 +++ postgresql-odbc/files/patch-odbcapi30.c 1970-01-01 12:00:00.000000000 +1200 @@ -1,13 +0,0 @@ ---- odbcapi30.c.orig 2009-01-26 23:20:59.000000000 +0600 -+++ odbcapi30.c 2009-01-26 23:21:47.000000000 +0600 -@@ -118,9 +118,7 @@ - SQLPOINTER CharacterAttribute, - SQLSMALLINT BufferLength, - SQLSMALLINT *StringLength, --#if defined(_WIN64) -- SQLLEN *NumericAttribute --#elif defined(WITH_UNIXODBC) || defined(WIN32) -+#if defined(WIN32) - SQLPOINTER NumericAttribute - #else - SQLLEN *NumericAttribute diff -urN postgresql-odbc.orig/files/patch-odbcapi30w.c postgresql-odbc/files/patch-odbcapi30w.c --- postgresql-odbc.orig/files/patch-odbcapi30w.c 2009-01-27 18:13:09.000000000 +1300 +++ postgresql-odbc/files/patch-odbcapi30w.c 1970-01-01 12:00:00.000000000 +1200 @@ -1,11 +0,0 @@ ---- odbcapi30w.c.orig 2009-01-26 23:23:19.000000000 +0600 -+++ odbcapi30w.c 2009-01-26 23:24:07.000000000 +0600 -@@ -255,7 +255,7 @@ - SQLPOINTER pCharAttr, - SQLSMALLINT cbCharAttrMax, - SQLSMALLINT *pcbCharAttr, --#if defined(WITH_UNIXODBC) || (defined(WIN32) && ! defined(_WIN64)) -+#if defined(WIN32) - SQLPOINTER pNumAttr - #else - SQLLEN *pNumAttr diff -urN postgresql-odbc.orig/pkg-plist postgresql-odbc/pkg-plist --- postgresql-odbc.orig/pkg-plist 2008-10-25 08:00:28.000000000 +1300 +++ postgresql-odbc/pkg-plist 2010-12-27 10:15:28.000000000 +1300 @@ -1,4 +1,5 @@ lib/psqlodbcw.la +lib/libpsqlodbcw.so.0.0 lib/psqlodbcw.so %%PORTDOCS%%%%DOCSDIR%%/odbc/config-opt.html %%PORTDOCS%%%%DOCSDIR%%/odbc/config.html -- All the best, Berend de Boer