-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 11/27/06 13:23, Harald Armin Massa wrote:
> 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.
There are lots of numbers. Credit card numbers, account numbers
sales ticket numbers, etc, etc ad nauseum. Julian day and Julian
date, even. You can't have lived in "the west" in the past 30 years
without being surrounded by them.
It's their blind use in *every* table which I take issue with, *most
especially* when they are the only unique key.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFFaz8HS9HxQb37XmcRAjbWAKCT2yN84OiemgPnCH2uc0JNMsykxACeOrfI
vNKts9gWRqq7U3hIyEVNKY8=
=mGfl
-----END PGP SIGNATURE-----