X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 98A6E52889 for ; Wed, 10 Aug 2005 06:34:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70442-07 for ; Wed, 10 Aug 2005 09:33:54 +0000 (GMT) Received: from mailbin.geodan.nl (unknown [194.109.122.3]) by svr1.postgresql.org (Postfix) with ESMTP id EAD8B5287F for ; Wed, 10 Aug 2005 06:33:52 -0300 (ADT) Received: from flaptop ([192.168.25.184]) by geodan.nl (geodan.nl [194.109.122.3]) (MDaemon.PRO.v8.1.1.R) with ESMTP id md50001466321.msg for ; Wed, 10 Aug 2005 11:34:03 +0200 From: "Johan C. de Koning" To: Subject: Getting oid with libpq Date: Wed, 10 Aug 2005 11:33:35 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C59D9F.58286390" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 thread-index: AcWdjpRNJJHHjqUzQPyUd8JnvsuH4w== X-Spam-Processed: geodan.nl, Wed, 10 Aug 2005 11:34:03 +0200 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.25.184 X-Return-Path: johan.de.koning@geodan.nl X-MDaemon-Deliver-To: pgsql-interfaces@postgresql.org Message-Id: <20050810093352.EAD8B5287F@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.755 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200508/12 X-Sequence-Number: 5683 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C59D9F.58286390 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I have stored some large objects (which are images) with the lo_import function. Now I can read the images with the other functions like lo_read within libpq. But I have one problem with the oid I have to give to this method. Inside my program I will do a select like this Select texture from building_face where face_id > 100; Textures is the oid field. When I use PQgetValue() I get a complete different value then when I do a select inside pgAdmin. How can I get the same oid so that I can use this for reading the data of the images inside my c++ program. Because it is not working with the oid from PQgetValue. Best regards, Johan de Koning ------=_NextPart_000_0000_01C59D9F.58286390 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

I have stored some large objects (which are = images) with the lo_import function. Now I can read the images with the other = functions like lo_read within libpq. But I have one problem with the oid I have to = give to this method. Inside my program I will do a select like = this

 

Select texture from building_face where = face_id > 100;

 

Textures is the oid field. When I use = PQgetValue() I get a complete different value then when I do  a select inside pgAdmin. = How can I get the same oid so that I can use this for reading the data of the images = inside my c++ program. Because it is not working with the oid from PQgetValue. =

 

Best regards,

 

Johan de Koning

 

 

------=_NextPart_000_0000_01C59D9F.58286390--