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

From Zeugswetter Andreas SB SD
Subject RE: AW: Re: OID wraparound: summary and proposal
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4212711@m0114.s-mxs.net
Whole thread Raw
List pgsql-hackers
> 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.
A lot of people seem to use OID, when they really could use XTID. That
is
what I wanted to say.

Andreas


pgsql-hackers by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: Vim!
Next
From: Alex Pilosov
Date:
Subject: Re: AW: Re: OID wraparound: summary and proposal