Re: [sqlalchemy] eager load polymorphic relation

2013-05-17 Thread Michael Bayer
Is there a reason you can't use subquery eager loading? That will at least use an inner join, but its true when sqla does an auto join from one entity to another, and the other is itself a join, it needs to parenthesize the target. And not every database historically has supported that so at

[sqlalchemy] eager load polymorphic relation

2013-05-17 Thread me
using python 2.7, sqla 0.7.9, postgresql 9.1 i'm trying to eager load a relationship to a polymorphic target (the target uses joined table inheritance). here is example: http://pastebin.com/xSiHS4QW and this is output: SELECT ... FROM container LEFT OUTER JOIN root AS root_