| From: | "Sander Steffann" <s(dot)steffann(at)computel(dot)nl> |
|---|---|
| To: | "'D'Arcy J(dot)M(dot) Cain'" <darcy(at)druid(dot)net>, "'David Clarke'" <pigwin32(at)gmail(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Alternative to serial primary key |
| Date: | 2006-07-07 13:26:47 |
| Message-ID: | 2B1A983EDCEC3447B22632B64F72646014EB1B@bill.office.computel.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi D'Arcy,
> It's not that I think that the primary key should never have
> meaning in the database (I use the two letter country code as
> the PK in my country table for example) I just think that
> it's dangerous ground and should be tread very carefully.
You are right. I now realize that I have done exactly the same thing in my
database designs :) In 95+% of the cases I would choose a serial, but this
is a good counter-example.
Thanks for making me think :)
Sander
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-07-07 13:33:35 | Re: How to get list of days between two dates? |
| Previous Message | Michael Glaesemann | 2006-07-07 13:14:16 | Re: Atomar SQL Statement |