[Melbourne-pm] DBIx::Class join errors ...

[Simon Taylor]

Hello Malcolm,

> I have been able to get around the issue by modifying my schema to
> append _id to the primary key fields, but I really shouldn't have to do
> that ...
>
> How would I go about fixing this properly? It sounds like a problem
> with the SQL query generator that DBIx::Class uses but as I am working
> at several layers removed from it, I'm a little at a loss as to how to
> attack this problem ...

This does sound like a bug in the automatic schema.

Have you tried making the references clause in the "show" table more 
specific, ie:

     channel uuid not null references channel (channel)

Cheers,

Simon