pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: [INTERFACES] calculated identity field in views,
3+ messages / 3 participants
[nested] [flat]
* Re: [INTERFACES] calculated identity field in views,
@ 2005-05-04 22:40 Ragnar Hafstað <gnari@simnet.is>
2005-05-04 23:00 ` Re: [INTERFACES] calculated identity field in views, Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ragnar Hafstað @ 2005-05-04 22:40 UTC (permalink / raw)
To: Jeff Eckermann <jeff_eckermann@yahoo.com>; +Cc: Zlatko Matic <zlatko.matic1@sb.t-com.hr>; pgsql-general@postgresql.org; pgsql-interfaces
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
gnari
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] calculated identity field in views,
2005-05-04 22:40 Re: [INTERFACES] calculated identity field in views, Ragnar Hafstað <gnari@simnet.is>
@ 2005-05-04 23:00 ` Joshua D. Drake <jd@commandprompt.com>
2005-05-04 23:27 ` Re: [INTERFACES] calculated identity field in views, Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Joshua D. Drake @ 2005-05-04 23:00 UTC (permalink / raw)
To: Ragnar Hafstað <gnari@simnet.is>; +Cc: Jeff Eckermann <jeff_eckermann@yahoo.com>; Zlatko Matic <zlatko.matic1@sb.t-com.hr>; pgsql-general@postgresql.org; pgsql-interfaces
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.
>
> gnari
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] calculated identity field in views,
2005-05-04 22:40 Re: [INTERFACES] calculated identity field in views, Ragnar Hafstað <gnari@simnet.is>
2005-05-04 23:00 ` Re: [INTERFACES] calculated identity field in views, Joshua D. Drake <jd@commandprompt.com>
@ 2005-05-04 23:27 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2005-05-04 23:27 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: Ragnar Hafstað <gnari@simnet.is>; Jeff Eckermann <jeff_eckermann@yahoo.com>; Zlatko Matic <zlatko.matic1@sb.t-com.hr>; pgsql-general@postgresql.org; pgsql-interfaces
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-05-04 23:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-04 22:40 Re: [INTERFACES] calculated identity field in views, Ragnar Hafstað <gnari@simnet.is>
2005-05-04 23:00 ` Joshua D. Drake <jd@commandprompt.com>
2005-05-04 23:27 ` Tom Lane <tgl@sss.pgh.pa.us>
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