Re: Alternative to serial primary key

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: Alternative to serial primary key
Дата
Msg-id 44ACF3FA.5080501@logix-tt.com
обсуждение исходный текст
Ответ на Re: Alternative to serial primary key  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: Alternative to serial primary key
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Alternative to serial primary key
Следующее
От: "David Clarke"
Дата:
Сообщение: Re: Alternative to serial primary key