Re: [sqlalchemy] joined table inhertiance and eager loading self-referencing relationships

2012-10-08 Thread Michael Bayer
On Oct 7, 2012, at 6:56 PM, Michael Bayer wrote: > > On Oct 7, 2012, at 2:17 AM, me wrote: > >> using python 2.7, sqla 0.7.9, postgresql 9.1 >> >> i've setup joined table inheritance and wanted an eager loaded relationship >> from one of the derived objects to another derived object. when i d

Re: [sqlalchemy] joined table inhertiance and eager loading self-referencing relationships

2012-10-07 Thread Michael Bayer
On Oct 7, 2012, at 2:17 AM, me wrote: > using python 2.7, sqla 0.7.9, postgresql 9.1 > > i've setup joined table inheritance and wanted an eager loaded relationship > from one of the derived objects to another derived object. when i do that i > get what seems to be a really inefficient query.

[sqlalchemy] joined table inhertiance and eager loading self-referencing relationships

2012-10-07 Thread me
using python 2.7, sqla 0.7.9, postgresql 9.1 i've setup joined table inheritance and wanted an eager loaded relationship from one of the derived objects to another derived object. when i do that i get what seems to be a really inefficient query. here is the minimal setup: http://pastebin.com/y