Re: OIDs overflow

Поиск
Список
Период
Сортировка
От Einar Karttunen
Тема Re: OIDs overflow
Дата
Msg-id Pine.LNX.4.33.0106141502250.25979-100000@melkinpaasi.cs.Helsinki.FI
обсуждение исходный текст
Ответ на OIDs overflow  ("Kapil Tilwani" <tilwani@yahoo.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: "Tamsin"
Дата:
Сообщение: RE: newbie:how can i get day of week data type...
Следующее
От: Stefan Mertl
Дата:
Сообщение: Can't connect to server (postgresql6.2.1)