From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Primary Key |
Date: | 2007-11-16 19:03:23 |
Message-ID: | 473DE97B.5000403@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 11/16/07 12:54, Sam Mason wrote:
> On Fri, Nov 16, 2007 at 03:50:20PM -0300, Jo??o Paulo Zavanela wrote:
>> How many fields is recomended to create a primary key?
>> I'm thinking to create one with 6 fields, is much?
>
> Normally a primary key would just be a single column. When you start
> going to that many I'd probably have a serial column as the primary key,
> and a UNIQUE index on those six fields. Depends on what you're doing,
> though unless you've got a few years experience I'd be tempted to stay
> away from primary keys of more than a single column.
Fie on you evil synthetic key lovers. Long live the Natural Key!
- --
Ron Johnson, Jr.
Jefferson LA USA
%SYSTEM-F-FISH, my hovercraft is full of eels
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHPel7S9HxQb37XmcRAmPZAJ9mml45XtPRSCrAiQ7K+LCwWf5J5QCgvaSp
Zs5F1SU5CNQvnoofaxkAoIY=
=9ipR
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2007-11-16 19:11:15 | Re: Primary Key |
Previous Message | Ron Johnson | 2007-11-16 19:01:19 | Re: Primary Key |