Re: pg_depend - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_depend
Date
Msg-id 6224.995477672@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_depend  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pg_depend
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I don't see any value in dropping oid from pg_attribute.

Conservation of OIDs.  Assigning an OID to every row of pg_attribute
chews up lots of OIDs, for a table that should never be referenced by
OID --- its primary key is (table OID, attribute number).

Right now this isn't really significant, but if/when we have an option
to suppress OID generation for user tables, I have every intention of
applying it to a bunch of the system tables as well.  pg_attribute is
a prime candidate.

("When" probably means "next month", btw.  This is on my 7.2 list...)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_depend
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: pg_depend