Re: OIDs overflow

On Wed, 9 May 2001, Kapil Tilwani wrote:

> By when, is serial and the OIDs expected to be converted to int8 or even int6 for that matter rather than int4.
>
> Also, what all transactions consume OIDs.  Is it true that every update, select and delete also consume OIDs or
> only objects created (including tables, view, rows, etc.) consume them.
> Even if all other transactions consume OIDs, isnt that a waste...
> Shouldnt OIDs be used simply to identify the objects.
>
Oids are only used when a new object is created. Transactions are
enumerated with xids. Oid overflow is not a very big problem but
with xid overflow IMHO bad things may happen.

- Einar Karttunen