Re: [CDBI] Fwd: find_or_create() barfs with constraints

> * Johnny Morano <jmorano@xxxxxxxx.xxx> [2005-08-03T06:14:40]

Ah sorry!

And thanks!

And I always created a multi-column primary key (with an index on a
autoincrement-column, usually called 'id') in the situation you
explained. I see it can be done easier too... :-/

cya!

On Wed, 2005-08-03 at 11:16 -0400, Ricardo SIGNES wrote:
> * Johnny Morano <jmorano@xxxxxxxx.xxx> [2005-08-03T06:14:40]
> > Isn't the primary key supposed always to be unique?
> > 
> > [...]
> > 
> > Correct me if I'm wrong of course ;-)
> 
> You're right, but off-point.  The question was about unique keys that
> aren't the primary key, not a primary key that isn't unique.
> 
> I might have a Kings of England database with three columns: monarchid,
> name, sequence.  monarchid is the primary id and must be unique, and
> then I could further specify that (name, sequence) form a unique index,
> apart from the primary key.  So, you can't have two Edward the Firsts.
> 
> _______________________________________________
> ClassDBI mailing list
> ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
        -- 

Johnny Morano | insaniac@xxxxxxxx.xxx | +32.473 894685
[ perl rookie ] | [ linux geek ] | [ web kid ] | [ all ]
'%*;s{}{ohn};s.$.n.;;%@;s|(.*?)$|$1y|;s%^%j%;%;;print;*%'

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi