Re: OID wraparound (was Re: pg_depend)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: OID wraparound (was Re: pg_depend)
Дата
Msg-id 200107182109.f6IL9cF12788@candle.pha.pa.us
обсуждение исходный текст
Ответ на RE: OID wraparound (was Re: pg_depend)  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Ответы Re: OID wraparound (was Re: pg_depend)  (Lamar Owen <lamar.owen@wgcr.org>)
Список 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 по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: OID wraparound (was Re: pg_depend)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: OID wraparound (was Re: pg_depend)