Re: AW: Re: OID wraparound: summary and proposal

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: AW: Re: OID wraparound: summary and proposal
Дата
Msg-id 3B6EAEC7.A9630CD9@tm.ee
обсуждение исходный текст
Ответ на RE: AW: Re: OID wraparound: summary and proposal  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
Zeugswetter Andreas SB SD wrote:
> 
> > It seems to me, I guess and others too, that the OID mechanism should
> be on a
> > per table basis. That way OIDs are much more likely to be unique, and
> TRUNCATE
> > on a table should reset it's OID counter to zero.
> 
> Seems to me, that this would be no different than a performance improved
> version
> of SERIAL.
> If you really need OID, you imho want the systemid tableid tupleid
> combo.

or (systemid.tableid.tupleid.versioninterval) if you want to be able to
time-travel

---------------
Hannu


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Re: AW: Re: OID wraparound: summary and proposal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question about todo item