Re: IS it a good practice to use SERIAL as Primary Key?
От | Joshua D. Drake |
---|---|
Тема | Re: IS it a good practice to use SERIAL as Primary Key? |
Дата | |
Msg-id | 1164660898.16182.84.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: IS it a good practice to use SERIAL as Primary Key? (Scott Ribe <scott_ribe@killerbytes.com>) |
Ответы |
Re: IS it a good practice to use SERIAL as Primary Key?
|
Список | pgsql-general |
On Mon, 2006-11-27 at 13:38 -0700, Scott Ribe wrote: > > primary key (first_name,last_name,address_id) > > > > One will enable you to have a distinct Joshua Drake, one in portland > > oregon and one in portland maine. > > What happens when you move? Do we treat you as a different person? Or do we > pretend that you've always lived in the same place? You would update the address, the address id wouldn't change. If you want to keep track of old addresses you would keep an archive table associated with the user.id. Sincerely, Joshua D. Drake > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
В списке pgsql-general по дате отправления: