From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Ragnar Hafstað <gnari@simnet.is>
Cc: Jeff Eckermann <jeff_eckermann@yahoo.com>
Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>
Cc: pgsql-general@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views,
Date: Wed, 04 May 2005 19:27:38 -0400
Message-ID: <1420.1115249258@sss.pgh.pa.us> (raw)
In-Reply-To: <4279542B.50104@commandprompt.com>
References: <20050504160124.8942.qmail@web20822.mail.yahoo.com>
<1115246450.17038.5.camel@localhost.localdomain>
<4279542B.50104@commandprompt.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, jd@commandprompt.com, gnari@simnet.is, jeff_eckermann@yahoo.com, zlatko.matic1@sb.t-com.hr, pgsql-general@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views,
In-Reply-To: <1420.1115249258@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox