Re: OIDs (Or: another RTFM question?) - Mailing list pgsql-general

From Curt Sampson
Subject Re: OIDs (Or: another RTFM question?)
Date
Msg-id Pine.NEB.4.44.0207191704390.13718-100000@angelic.cynic.net
Whole thread Raw
In response to Re: OIDs (Or: another RTFM question?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: OIDs (Or: another RTFM question?)
List pgsql-general
On Thu, 18 Jul 2002, Tom Lane wrote:

> Curt Sampson <cjs@cynic.net> writes:
> > I have grave doubts as to how practical this would be, but what
> > you do think of just getting rid of OIDs entirely?
>
> It's quite impractical as far as the system's internal uses go; if you
> tried, you'd just have to invent some other, equivalent concept.

Why couldn't you just add an ID column to the system tables, and
use the number you put in that?

I also think it would make sense to have OIDs off by default, if
we're going to keep them, as they sort of invisibly take up space
if you're not using them. But on the other hand, that may not be
practical from a backwards compatability point of view.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Can't link to libpq
Next
From: Stephane Bortzmeyer
Date:
Subject: Re: Logging SQL queries?