Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] calculated identity field in views,

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Ragnar HafstaĆ° <gnari(at)simnet(dot)is>,Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>,Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>,pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] calculated identity field in views,
Date: 2005-05-04 23:27:38
Message-ID: 1420.1115249258@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
"Joshua D. Drake" <jd(at)commandprompt(dot)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

In response to

pgsql-interfaces by date

Next:From: Greg Sabino MullaneDate: 2005-05-05 01:10:48
Subject: Re: [INTERFACES] DBD::Pg and .pgpass
Previous:From: Joshua D. DrakeDate: 2005-05-04 23:00:59
Subject: Re: [INTERFACES] calculated identity field in views,

pgsql-general by date

Next:From: Greg Sabino MullaneDate: 2005-05-04 23:44:18
Subject: Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found
Previous:From: Joshua D. DrakeDate: 2005-05-04 23:00:59
Subject: Re: [INTERFACES] calculated identity field in views,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group