[CDBI] add new columns to a table will break exi sting class?

Matt S Trout dbix-class at trout.me.uk
Wed May 24 23:36:15 BST 2006


Bill Moseley wrote:
> On Wed, May 24, 2006 at 03:24:05PM +0100, Matt S Trout wrote:
>>> No, you must have a primary key.
>> You can often get round this by simply declaring the primary key as a 
>> composite of all columns - but it's very rare you *really* don't want a 
>> primary key. Usually lack of a primary key is just shoddy database design.
> 
> None of my link tables have a single primary key.
> 
>     PersonRole->columns( Primary => qw / person role / );

That's a single primary key.

It just happens to be a primary key made up of two columns.




More information about the ClassDBI mailing list