I hadn't updated in several weeks so I am not sure when this issue first arose but with the following setup:
---------------------------- mapper(Section, section_table, properties = {'items': relation(Item, backref='section'), 'keywords':relation(Keyword, primaryjoin=and_(keyword_table.c.uuid==itemkeyword_table.c.keyword_uuid, item_table.c.uuid==itemkeyword_table.c.item_uuid, section_table.c.id==item_table.c.section_id), viewonly=True, foreignkey=keyword_table.c.uuid)}) mapper(Item, item_table, properties = dict(itemkeywords = relation(ItemKeyword, lazy=False, backref='item'), reminder = relation(Reminder, backref='item'), children = relation(Item, remote_side=[item_table.c.parent_uuid], backref=backref('parent', remote_side=[item_table.c.uuid])), note = deferred(item_table.c.note), )) mapper(Keyword, keyword_table) mapper(ItemKeyword, itemkeyword_table, properties={'keyword': relation(Keyword, lazy=False, backref='itemkeywords')}) ---------------------------------- when I ask for: some_section.keywords I get the following exception: sqlalchemy.exceptions.InvalidRequestError: No column item_keyword.keyword_uuid is configured on mapper Mapper|Section|section... Prior to updating today, this worked fine and produced the expected results. Let me know if it would help to see the tables and classes. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---