-----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-----