Re: OIDs (Or: another RTFM question?)

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: OIDs (Or: another RTFM question?)
Date: 2002-07-19 08:06:30
Message-ID: Pine.NEB.4.44.0207191704390.13718-100000@angelic.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 18 Jul 2002, Tom Lane wrote:

> Curt Sampson <cjs(at)cynic(dot)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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephane Bortzmeyer 2002-07-19 08:21:10 Re: Logging SQL queries?
Previous Message Oliver Elphick 2002-07-19 08:01:26 Re: Can't link to libpq