Re: Alternative to serial primary key

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Alternative to serial primary key
Date: 2006-07-06 11:28:58
Message-ID: 44ACF3FA.5080501@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Clarke 2006-07-06 11:32:36 Re: Alternative to serial primary key
Previous Message Andrew Sullivan 2006-07-06 11:12:23 Re: Alternative to serial primary key