Re: IS it a good practice to use SERIAL as Primary Key?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Nov 27, 2006, at 1:21 PM, Brandon Aiken wrote:
> The other argument is that it's redundant data with no real meaning to
> the domain, meaning using surrogate keys technically violates low-
> order
> normal forms.

It has real meaning in the sense that it is an internal identifier
that doesn't change.   My bank set my online login to a stupid 5
letters of my name plus last four digits of SSN, and they "can not
change" it.   Most likely, it is the primary key used for as a
foreign key to all the financial data.   Dumb, dumb, dumb.

If, OTOH, they would go with an internal id, it would be trivial to
change the login id.

David Morton
Maia Mailguard http://www.maiamailguard.com
mortonda@dgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFFazzQUy30ODPkzl0RAs/sAJ9rBTbXPNN/T4eQ9zjJFMAKFpfrPACdHcLj
pVtAZhjxk24vgRm/ScNfuyw=
=mLTC
-----END PGP SIGNATURE-----