Re: new interface

> -----Original Message-----
> From: Rod Taylor [mailto:rbt(at)rbt(dot)ca]
> Sent: Friday, December 06, 2002 9:19 AM
> To: Reggie Burnett
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] new interface
>
> On Fri, 2002-12-06 at 09:55, Reggie Burnett wrote:
> > 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 OID is just a relatively unique database wide row marker -- which
> you cannot count on existing in user tables. Nothing more or less.
In
> some of the system tables it is used as a foreign key to records in
> other system tables, but Oid by itself has no such meaning.

So if OID can't be counted on to be there 100% of the time, what do I
use to index the catalog to determine type, not null-ness, uniqueness,
etc?

>
> >
> > I have read through all the docs/faqs I can find and still have no
good
> > idea about this.
>
> Take a look at the 'System Catalog' documentation, and in psql the -E
> option will show you the 'system' queries used to retrieve the
> information for display in psql.

>
> --
> Rod Taylor <rbt(at)rbt(dot)ca>
>
> PGP Key: http://www.rbt.ca/rbtpub.asc