Re: new interface - Mailing list pgsql-hackers

From Reggie Burnett
Subject Re: new interface
Date
Msg-id 000f01c29d3b$01e7b970$4100a8c0@endeavor
Whole thread Raw
In response to Re: new interface  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers

> -----Original Message-----
> From: Rod Taylor [mailto:rbt@rbt.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@rbt.ca>
> 
> PGP Key: http://www.rbt.ca/rbtpub.asc



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: new interface
Next
From: "Reggie Burnett"
Date:
Subject: Re: new interface