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

[John McCawley <nospam@xxxxxxxxxxxx>]

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