X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2DCEB9DD5F8; Tue, 6 Dec 2005 14:44:17 -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 63251-03; Tue, 6 Dec 2005 14:44:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.pzkagis.cz (gis6.netbox.cz [83.240.30.214]) by postgresql.org (Postfix) with ESMTP id 8E90C9DD5F7; Tue, 6 Dec 2005 14:44:08 -0400 (AST) Received: (from luf@localhost) by smtp.pzkagis.cz (8.11.6/8.11.6) id jB6Ii2924565; Tue, 6 Dec 2005 19:44:02 +0100 Date: Tue, 6 Dec 2005 19:44:02 +0100 From: Ludek Finstrle To: Tom Lane Cc: pgsql-interfaces@postgresql.org, pgsql-odbc@postgresql.org Subject: Re: [ODBC] BLOB handling compatibility with PostgreSQL > 7.4 Message-ID: <20051206184402.GA24475@soptik.pzkagis.cz> References: <438B792D.6030802@bnl.gov> <20051205212806.GA17690@soptik.pzkagis.cz> <20051206142811.GA23334@soptik.pzkagis.cz> <259.1133881501@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <259.1133881501@sss.pgh.pa.us> User-Agent: Mutt/1.4i 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: 200512/8 X-Sequence-Number: 5876 > > Irina reports problem with ODBC. I take deep look at it and find that > > libpq returns base type oid instead of type oid. I'll describe it better. > > Yes, this was an intentional backend-side change. For most purposes > it's the right thing. Is there any way to get type oid? Or we have to exec another query againist system tables to get type oid. Or is there any other flag saying we can use lo_import for the column? I don't want to reinvent the wheel. Thanks Luf