Re: IS it a good practice to use SERIAL as Primary Key?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Date: 2006-11-27 20:38:00
Message-ID: C1909AB8.5C27E%scott_ribe@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> primary key (first_name,last_name,address_id)
>
> One will enable you to have a distinct Joshua Drake, one in portland
> oregon and one in portland maine.

What happens when you move? Do we treat you as a different person? Or do we
pretend that you've always lived in the same place?

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Mayer 2006-11-27 20:44:27 Unexpected sort order.
Previous Message Scott Ribe 2006-11-27 20:34:11 Re: IS it a good practice to use SERIAL as Primary Key?