Re: OID wraparound (was Re: pg_depend)

> >> I meant we use them in many cases to link entries, and in
> >> pg_description for descriptions and lots of other things
> >> that may use them in the future for system table use.
>
> pg_description is a point I hadn't thought about --- it uses OIDs
> to refer to pg_attribute entries. However, pg_description is pretty
> broken in its assumptions about OIDs anyway. I'm inclined to change
> it to be indexed by
>
> (object type ID, object OID, attributenumber)
>
> the same way that Philip proposed indexing pg_depend. Among other
> things, that'd make it much cheaper to drop comments during a DROP
> TABLE. You could just scan on (object type ID, object OID), and get
> both the table and all its columns in a single indexscan search,
> not one per column as happens now.

Remember most pg_description comments are not on column but on functions
and stuff. That attributenumber is not going to apply there.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026