| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-05-04 23:44:18 | Re: [ANNOUNCE] IMPORTANT: two new PostgreSQL security problems found |
| Previous Message | Joshua D. Drake | 2005-05-04 23:00:59 | Re: [INTERFACES] calculated identity field in views, |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2005-05-05 01:10:48 | Re: [INTERFACES] DBD::Pg and .pgpass |
| Previous Message | Joshua D. Drake | 2005-05-04 23:00:59 | Re: [INTERFACES] calculated identity field in views, |