Re: Using oids

Поиск
Список
Период
Сортировка
От Jonathan Bartlett
Тема Re: Using oids
Дата
Msg-id Pine.GSU.4.44.0309031253190.23907-100000@eskimo.com
обсуждение исходный текст
Ответ на Re: Using oids  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
> About oids not being unique, oids can assume 4 billion different values. If you
> have more than those many rows in a table, oids will wrap around and will no
> longer be unique in that object.

Not quite.  After 4 billion inserts (even spread across millions of
tables), you run out of OIDs and they will no longer be unique.  OIDs I
think were originally meant to be globally unique identifiers, but they
are no longer so, and are really no longer useful.  When I want globally
unique identifiers, I use an int8 column + sequence.

Jon


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

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