From: jtv@xs4all.nl
To: Johan C. de Koning <johan.de.koning@geodan.nl>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Getting oid with libpq
Date: Wed, 10 Aug 2005 12:52:12 +0200 (CEST)
Message-ID: <10445.202.47.227.25.1123671132.squirrel@202.47.227.25> (raw)
In-Reply-To: <20050810093352.EAD8B5287F@svr1.postgresql.org>
References: <20050810093352.EAD8B5287F@svr1.postgresql.org>
Johan C. de Koning wrote:
> 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.
Just a guess, but...
One mistake many people make is to cast the char * returned by
PQgetValue() to the type they expect to get. Which won't work, since it's
a pointer to a value (in this case a number) in a textual format. It
needs to be parsed so you get the actual numeric value.
Also, when you parse the number, be aware that the standard-library
functions (such as sscanf()) take the applicable locale setting into
account--which is not what you want in this case. Best reset to the
default locale before parsing.
Jeroen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jtv@xs4all.nl, johan.de.koning@geodan.nl
Subject: Re: Getting oid with libpq
In-Reply-To: <10445.202.47.227.25.1123671132.squirrel@202.47.227.25>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox