[Catalyst] many to many join with multicolumn primary key

[jmo mlists]

Hi,

On Tue, Aug 21, 2012 at 5:10 PM, bill hauck <wbhauck at yahoo.com> wrote:

> Hi.
>
> Posted this to the DBIx::Class maillist, but not getting an traction
> there.  Perhaps someone else has run into this issue on a Catalyst app.
>
>
> I need to connect two tables through a relation table for a many_to_many.
>  The issue I'm running into is that one of the tables has a composite
> primary key.  I'm using this in a Catalyst application through a Template
> Toolkit template.
>
> So, before going through the whole thing, is it possible to have a
> composite primary key used in many to many?  If not, any suggestions on a
> workaround?
>
> If it is possible, here's my setup.  The user will submit issues into
> complexity_submission.  A trigger will create a duplicate entry in table
> complexity giving the unique post id and then a version of the post.
>
> Tables, trigger, Schema::Result relations listed, and template below.
>
>
Did you try the way suggested here?
http://grokbase.com/t/sc/dbix-class/071g80741a/multi-column-primary-foreign=
-key

/Jon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120822/9eb01=
dc9/attachment.htm