Re: [sqlalchemy] sqlalchmey 0.8 stuck on a join with reflected tables

2013-10-12 Thread Michael Bayer
On Oct 12, 2013, at 10:35 PM, Iain Duncan wrote:I set up my table  and my mappers like so:appurl_table = Table("appurls", metadata,     Column('tierid', Integer, ForeignKey('tier.tierid'), primary_key=True ),     Column('groupagentid', Integer, ForeignKey('groupagent.gro

[sqlalchemy] sqlalchmey 0.8 stuck on a join with reflected tables

2013-10-12 Thread Iain Duncan
Hey folks, hit a new error message and the googling is not turning up much, and as I'm new to postgres, I'm frankly over my head. I have a wack of reflected tables and I'm trying to get a join working. The one I'm ultimately after has a composite primary key of 2 different foreign keys and an int (