-----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----- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
