Re: [INTERFACES] calculated identity field in views,

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [INTERFACES] calculated identity field in views,
Дата
Msg-id 1420.1115249258@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [INTERFACES] calculated identity field in views,  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
"Joshua D. Drake" <jd@commandprompt.com> writes:
> Ragnar Hafsta� wrote:
>> On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
>>> If I understand right, oids are globally
>>> unique within your database.
>>
>> I am affraid not

> oids are globally unique within the catalog.

... until the OID generator wraps around, and then they aren't so
unique anymore.

You can enforce uniqueness within a particular table by creating
a unique index on the OID column, but that's about as much as
you can guarantee.

            regards, tom lane

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [INTERFACES] calculated identity field in views,
Следующее
От: Vlad
Дата:
Сообщение: postgresql replication