Re: IS it a good practice to use SERIAL as Primary Key? - Mailing list pgsql-general

From John McCawley
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id 456B756B.9080303@hardgeus.com
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: IS it a good practice to use SERIAL as Primary Key?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
I promise I'm not trying to be a pain in the butt ;)  Do you then use
your serial id as your foreign key in other tables, or the
firstname/lastname primary key?

Joshua D. Drake wrote:

>users
>=====
>id serial unique,
>first_name text,
>last_name text,
>primary key (first_name,last_name)
>
>Yes there are problems with the above, namely you will likely have more
>than one joshua drake.
>
>Sincerely,
>
>Joshua D. Drake
>
>
>>
>>

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Next
From: Scott Ribe
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?