Re: Primary Key - Mailing list pgsql-general

From Peter Childs
Subject Re: Primary Key
Date
Msg-id a2de01dd0711230133v27f17b97y4e16937e092a168f@mail.gmail.com
Whole thread Raw
In response to Re: Primary Key  (Sascha Bohnenkamp <asbohnenkamp@gmx.de>)
Responses Re: Primary Key  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Primary Key  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general


On 21/11/2007, Sascha Bohnenkamp <asbohnenkamp@gmx.de> wrote:
> Fie on you evil synthetic key lovers.  Long live the Natural Key!

think of an foreign key referencing a primary key with 6 columns *urgs*
never!


The worse thing I meet is people who think primary keys need to be integer single field unique serial fields

I tend to agree that primary keys should be single fields if they need to be referenced but should also be natural if at all possible. ie use car number plates rather than some serial int.

Peter.

pgsql-general by date:

Previous
From: "Peter Childs"
Date:
Subject: Re: Unused item pointers - can someone explain?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Primary Key