Re: Alternative to serial primary key - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Alternative to serial primary key
Date
Msg-id 44ACF3FA.5080501@logix-tt.com
Whole thread Raw
In response to Re: Alternative to serial primary key  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Alternative to serial primary key  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
Hi, Andrew,

Andrew Sullivan wrote:
> On Thu, Jul 06, 2006 at 01:10:55PM +0200, Markus Schaber wrote:
>> Then you'll have to use the re-check approach, like:
> 
> That sort of undermines the value of the calculated primary key,
> though, doesn't it?  He'd need the unique index for FK references,
> which was the point, I thought.

Yes, risking collisions. It will work for some time, and then create a
maintainance nightmare for his successors. :-)


Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Alternative to serial primary key
Next
From: "David Clarke"
Date:
Subject: Re: Alternative to serial primary key