From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Bo Lorentsen <bl(at)netgroup(dot)dk> |
Cc: | Greg Stark <gsstark(at)mit(dot)edu>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Using oids |
Date: | 2003-09-04 02:40:11 |
Message-ID: | 20030904024011.GB16796@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Wed, Sep 03, 2003 at 10:08:47PM +0200, Bo Lorentsen wrote:
> On Wed, 2003-09-03 at 18:24, Greg Stark wrote:
>
> I am maintaining a driver layer, so that exactly why I care about this
> kind of problem :-)
>
> > The pros: no extra overhead for OIDs, more portable to other databases.
> So when will this kind of meta data be provided, to let me detect if
> there is at "PRIMARY KEY" on a table. ?
That metadata has been around for a while, it's all stored in the system
tables. It's not returned with each query though. pg_attribute and pg_class
tell you almost everything you need to know.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-04 02:44:25 | Re: Optimizer picks an ineffient plan |
Previous Message | Alvaro Herrera | 2003-09-04 02:29:47 | Re: Comparing dates |
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Kavan | 2003-09-04 02:50:35 | Stats Collector Error 7.4beta1 and 7.4beta2 |
Previous Message | Tom Lane | 2003-09-04 02:30:05 | Re: compile warnings in CVS HEAD? |