Re: [INTERFACES] calculated identity field in views, - Mailing list pgsql-general

From Tom Lane
Subject Re: [INTERFACES] calculated identity field in views,
Date
Msg-id 1420.1115249258@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] calculated identity field in views,  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [INTERFACES] calculated identity field in views,
Next
From: Vlad
Date:
Subject: postgresql replication