From owner-freebsd-bugs@FreeBSD.ORG Wed Mar 24 02:30:03 2010 Return-Path: Delivered-To: freebsd-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 77F20106566C for ; Wed, 24 Mar 2010 02:30:03 +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 031008FC19 for ; Wed, 24 Mar 2010 02:30:03 +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 o2O2U2bp088214 for ; Wed, 24 Mar 2010 02:30:02 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id o2O2U2Pn088212; Wed, 24 Mar 2010 02:30:02 GMT (envelope-from gnats) Resent-Date: Wed, 24 Mar 2010 02:30:02 GMT Resent-Message-Id: <201003240230.o2O2U2Pn088212@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Berend de Boer Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 7879E106566B for ; Wed, 24 Mar 2010 02:22:56 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 676528FC19 for ; Wed, 24 Mar 2010 02:22:56 +0000 (UTC) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.3/8.14.3) with ESMTP id o2O2MuUg034417 for ; Wed, 24 Mar 2010 02:22:56 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.3/8.14.3/Submit) id o2O2Mtvr034416; Wed, 24 Mar 2010 02:22:56 GMT (envelope-from nobody) Message-Id: <201003240222.o2O2Mtvr034416@www.freebsd.org> Date: Wed, 24 Mar 2010 02:22:56 GMT From: Berend de Boer To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: misc/144993: databases/postgresql-odbc: contents of numeric fields returned as 0 X-BeenThere: freebsd-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 Mar 2010 02:30:03 -0000 >Number: 144993 >Category: misc >Synopsis: databases/postgresql-odbc: contents of numeric fields returned as 0 >Confidential: no >Severity: critical >Priority: low >Responsible: freebsd-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Wed Mar 24 02:30:02 UTC 2010 >Closed-Date: >Last-Modified: >Originator: Berend de Boer >Release: 8 >Organization: Xplain Technology Ltd >Environment: FreeBSD emes.servaris.com 8.0-STABLE FreeBSD 8.0-STABLE #0: Mon Mar 15 19:07:58 EDT 2010 root@ohr.servaris.com:/usr/obj/usr/src/sys/OHR amd64 >Description: After installing the postgresql ODBC driver version 8.04 numeric fields return 0.00. Solution is to install the previous version, version postgresql-odbc-08.03.0400. PostgreSQL version is 8.4. Data is retrieved through unixODBC with the PostgreSQL ODBC driver, through the Eiffel ECLI (ODBC binding) library. After some testing I don't believe the problem is with this Eiffel binding, as just a minor release back everything works. All other datatypes are OK. >How-To-Repeat: >Fix: Install the previous version, version postgresql-odbc-08.03.0400. >Release-Note: >Audit-Trail: >Unformatted: