A couple of LIBPQ questions

On Fri, 5 Jun 1998, Bruce Tong wrote:

(1) PQftype() returns a value of type "Oid", but I haven't been able to
find a list of what those values might be. I noticed in the header files a
value of zero is considered invalid, but that's it. The docs I've found
don't tell me anything other than it an integer code representing the
type. What are the possible values?

select oid,* from pg_type where oid = <type_oid>

where <type_oid> is between 16 and 32

(2) I noticed there are some C++ classes in /usr/include/libpq++ which
look similar to code I'm writing for my own education and use. Is there
any documentation which deals with these classes? (I've not seen any thus
far.)

Neither did I.

(3) The third paramter to PQsetdb() is pgoptions. I've not found any
description of what these options might be. Where can I find a list of the
options?

The source says this is for setting backend options for this connection.

man postgres

to see the backend options.

Hope this helps..

Marin

-= Why do we need gates in a world without fences? =-

On Sat, 6 Jun 1998, Marin D wrote:

(2) I noticed there are some C++ classes in /usr/include/libpq++ which
look similar to code I'm writing for my own education and use. Is there
any documentation which deals with these classes? (I've not seen any thus
far.)

Neither did I.

Silly to correct myself but there is a nice man page

man libpq++

Best regards

Marin

-= Why do we need gates in a world without fences? =-

(1) PQftype() returns a value of type "Oid", but I haven't been able to
find a list of what those values might be. I noticed in the header files a
value of zero is considered invalid, but that's it. The docs I've found
don't tell me anything other than it an integer code representing the
type. What are the possible values?

select oid,* from pg_type where oid = <type_oid>

where <type_oid> is between 16 and 32

Thats interesting. How in the world did you ever know to look there?

(3) The third paramter to PQsetdb() is pgoptions. I've not found any
description of what these options might be. Where can I find a list of the
options?

The source says this is for setting backend options for this connection.

man postgres

to see the backend options.

Ahhh, I see. Boy I feel dumb for not having made that connection.

Bruce Tong
Systems Programmer
Electronic Vision / FITNE

mailto: zztong@laxmi.ev.net
http://www.ev.net/fitne

(2) I noticed there are some C++ classes in /usr/include/libpq++ which
look similar to code I'm writing for my own education and use. Is there
any documentation which deals with these classes? (I've not seen any thus
far.)

Neither did I.

Silly to correct myself but there is a nice man page

man libpq++

So there is. I'm kicking myself now since I had found the libpq man page.
Ahh, I see. They've put the developer stuff in another RPM, so none of
this was showing up in the list of files belonging to the postgresql
package. This will give me some more things to look at.

Thanks a bunch.

Bruce Tong
Systems Programmer
Electronic Vision / FITNE

mailto: zztong@laxmi.ev.net
http://www.ev.net/fitne