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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
