Re: OIDs overflow - Mailing list pgsql-general

From Einar Karttunen
Subject Re: OIDs overflow
Date
Msg-id Pine.LNX.4.33.0106141502250.25979-100000@melkinpaasi.cs.Helsinki.FI
Whole thread Raw
In response to OIDs overflow  ("Kapil Tilwani" <tilwani@yahoo.co.uk>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Tamsin"
Date:
Subject: RE: newbie:how can i get day of week data type...
Next
From: Stefan Mertl
Date:
Subject: Can't connect to server (postgresql6.2.1)