From: | "Sally Sally" <dedeb17(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | primary key and existing unique fields |
Date: | 2004-10-26 16:24:44 |
Message-ID: | BAY101-F32W8BYXifWo0000151b@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I am wandering about the pros and cons of creating a separate serial field
for a primary key when I already have a single unique field. This existing
unique field will have to be a character of fixed length (VARCHAR(12))
because although it's a numeric value there will be leading zeroes. There
are a couple more tables with similar unique fields and one of them would
need to reference the others. Does anybody see any good reason for adding a
separate autoincrement primary key field for each table? or either way is
not a big deal.
Sally
_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Duane Lee - EGOVX | 2004-10-26 16:46:15 | Re: primary key and existing unique fields |
Previous Message | Thomas Hallgren | 2004-10-26 16:21:23 | Re: Bug or stupidity |