Re: IS it a good practice to use SERIAL as Primary Key? - Mailing list pgsql-general

From psql@dgrmm.net
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id C9CCDD34-2C5A-41D1-987A-63B90EDE70A9@dgrmm.net
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  ("Brandon Aiken" <BAiken@winemantech.com>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: "rbaisak"
Date:
Subject: DB crashed
Next
From: Ray Stell
Date:
Subject: Re: Solaris 10 problem