From: Reggie Burnett <rykr@bellsouth.net>
To: pgsql-interfaces@postgresql.org
Subject: client interface docs
Date: Thu, 5 Dec 2002 23:06:16 -0600
Message-ID: <000901c29ce5$3506ff10$4100a8c0@endeavor> (raw)
I'm working on a new interface to PostgreSQL and having a difficult
time.
Perhaps someone here can shed some light on the subject.
1. Am I correct in thinking that the OID that I receive with the
RowDescription is the column type? I have several of those defined from
the
7.3 source code. Have those changed in the past and are they likely to
change in the future? I have heard people talking about querying the
server
for type names or type oid values but I can't believe it is that
difficult.
2. How do I receive the column modifers such as not null, primary key,
indexed, etc. I know RowDescription sends down type modifiers but on an
int4 column that field is always -1. I use another client app to change
the
column from allowing nulls to not allowing nulls (same value in column).
The client app as well as psql on Linux sees the change but my interface
still receives just -1 for the type modifier. What am I missing?
If there is someplace that has the oids documented or the low-level
constants documented, I would love to see that.
Thanks
Reggie
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: rykr@bellsouth.net
Subject: Re: client interface docs
In-Reply-To: <000901c29ce5$3506ff10$4100a8c0@endeavor>
* 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