primary key and existing unique fields
От | Sally Sally |
---|---|
Тема | primary key and existing unique fields |
Дата | |
Msg-id | BAY101-F32W8BYXifWo0000151b@hotmail.com обсуждение исходный текст |
Ответы |
Re: primary key and existing unique fields
Re: primary key and existing unique fields Re: primary key and existing unique fields |
Список | 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 _________________________________________________________________ Don�t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
В списке pgsql-general по дате отправления: