So then I thought: maybe I just need to reflect the skiboots table and override the size column to the desired type? That would make sense... so I tried it, using the same script as above but adding the line "autoload=True" as the final clause in each Table definition.
Now i'm getting a different error: sqlalchemy.exceptions.ArgumentError: Can't determine join between 'items' and 'skis'; tables have more than one foreign key constraint relationship between them. Please specify the 'onclause' of this join explicitly. Ok, so my item_join definition was too loose. Changed the ski and skiboot lines in it to read: 'ski':join(items, skis, items.c.id==skis.c.id), 'skiboot':join(items, skiboots, items.c.id==skiboots.c.id) ...and still get the same error. How much more specific can I get with my onclause? In each case the items table and each of its children are only joined by a single column, 'id'. I can't see that the 'items' and 'skis' table have more than one foreign key constraint relationship between them. What am i missing? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---