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

Bill Moseley moseley at hank.org
Thu May 25 03:25:50 BST 2006


On Wed, May 24, 2006 at 11:36:15PM +0100, Matt S Trout wrote:
> 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.

Yes, I misread your post.  I have seen examples of CDBI link tables
that also have an integer primary key in addition to the link fields.


-- 
Bill Moseley
moseley at hank.org




More information about the ClassDBI mailing list