X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 50E089DCC7D for ; Mon, 28 Nov 2005 20:50:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73061-09 for ; Mon, 28 Nov 2005 20:50:40 -0400 (AST) X-Greylist: delayed 03:10:29.279818 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 709D99DCC69 for ; Mon, 28 Nov 2005 20:50:34 -0400 (AST) Received: from smtpgateway.bnl.gov (smtpgateway.bnl.gov [130.199.3.132]) by svr2.postgresql.org (Postfix) with ESMTP id F2A35F0B0B for ; Mon, 28 Nov 2005 21:40:06 +0000 (GMT) Received: from rcf.rhic.bnl.gov ([130.199.80.226]) by smtpgateway.bnl.gov with esmtp (bnl.gov SMTP) id 1Egqj9-000366-03 for ; Mon, 28 Nov 2005 16:39:59 -0500 Received: from bnl.gov (nuvi.rhic.bnl.gov [130.199.80.30]) by rcf.rhic.bnl.gov (8.12.11/8.12.11) with ESMTP id jASLdvfp027538 for ; Mon, 28 Nov 2005 16:39:57 -0500 Message-ID: <438B792D.6030802@bnl.gov> Date: Mon, 28 Nov 2005 16:39:57 -0500 From: Irina Sourikova User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030922 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-odbc@postgresql.org Subject: BLOB handling compatibility with PostgreSQL > 7.4 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-BNL-MailScanner-Information: Please contact the ITD Service Desk for more information X-BNL-MailScanner: Found to be clean X-BNL-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=0.088, required 5, autolearn=disabled, AWL 0.09) X-MailScanner-From: irina@bnl.gov X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/232 X-Sequence-Number: 6468 Dear experts, We would like to upgrade the Postgres version from our current 7.3 but have problems with handling BLOBs via ODBC. We use unixODBC-2.2.11 and psqlodbc-08.01.0101. With postgres 7.3 lo type was mapped to SQL_C_BINARY and that's changed since postgres 7.4. Is it an ODBC or a driver issue? Are there any plans to fix the problem? Thank you, Irina -- Irina Sourikova Brookhaven National Laboratory phone: +1-631-344-3776 Physics Department, Bldg 510 C fax: +1-631-344-3253 Upton, NY 11973-5000 email: irina@bnl.gov