Re: OID wraparound (was Re: pg_depend) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: OID wraparound (was Re: pg_depend)
Date
Msg-id 200107182109.f6IL9cF12788@candle.pha.pa.us
Whole thread Raw
In response to RE: OID wraparound (was Re: pg_depend)  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Responses Re: OID wraparound (was Re: pg_depend)  (Lamar Owen <lamar.owen@wgcr.org>)
List pgsql-hackers
> > If you want to make oids optional on user tables,
> > we can vote on that.
> 
> Let's vote. I'm proposing optional oids for 2-3 years,
> so you know how I'll vote -:)

OK, we need to vote on whether Oid's are optional, and whether we can
have them not created by default.

> 
> > However, OID's keep our system tables together.
> 
> How?! If we want to find function with oid X we query
> pg_proc, if we want to find table with oid Y we query
> pg_class - we always use oids in context of "class"
> to what an object belongs. This means that two tuples
> from different system tables could have same oid values
> and everything would work perfectly.

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.

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


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: OID wraparound (was Re: pg_depend)
Next
From: Tom Lane
Date:
Subject: Re: OID wraparound (was Re: pg_depend)