Re: AW: Re: OID wraparound: summary and proposal - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: AW: Re: OID wraparound: summary and proposal
Date
Msg-id 3B6EAEC7.A9630CD9@tm.ee
Whole thread Raw
In response to RE: AW: Re: OID wraparound: summary and proposal  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List 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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Re: AW: Re: OID wraparound: summary and proposal
Next
From: Tom Lane
Date:
Subject: Re: Question about todo item