Re: Using oids

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using oids
Дата
Msg-id 14686.1062624747@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Using oids  (Jonathan Bartlett <johnnyb@eskimo.com>)
Список pgsql-general
Jonathan Bartlett <johnnyb@eskimo.com> writes:
>>> If you want a globally unique ID based on OIDs, use the table OID
>>> concatenated with the row OID.

>> Ok, this make sense !

> Are you sure this works after you hit the 4 billion mark?

If you have a unique index on OID on each table for which you care, yes.

As someone else pointed out, you do then have to cope with the
possibility of insertions failing because of OID conflicts.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Josué Maldonado
Дата:
Сообщение: Re: TCL trigger doesn't work after deleting a column
Следующее
От: Bo Lorentsen
Дата:
Сообщение: Re: Using oids