[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