| From: | "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com> |
|---|---|
| To: | "John McCawley" <nospam(at)hardgeus(dot)com> |
| Cc: | "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: IS it a good practice to use SERIAL as Primary Key? |
| Date: | 2006-11-27 19:23:02 |
| Message-ID: | 7be3f35d0611271123h2d298eb7m893e419d691f5f57@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John,
I'll weigh in my my .02 on this subject. After much pain and agony in
> the real world, I have taken the stance that every table in my database
> must have an arbitrary, numeric primary key (generally autogenerated).
I feel the same.
In the "real world" there is no such thing as a primary key. At least not
over time. Not enough people understand the concept of a primary key to make
those things existent in the real world.
So we take an artificially primary key - and most reliable way is to create
it yourself.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rbaisak | 2006-11-27 19:26:10 | DB crashed |
| Previous Message | Brandon Aiken | 2006-11-27 19:21:07 | Re: IS it a good practice to use SERIAL as Primary Key? |