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

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
>
>
>>
>>