[sqlalchemy] Re: 0.5.2, orm, deferring joined columns during query construction

2009-03-14 Thread me
Thanks for the help! Specifying path as a string relative to the root of the query properly defers the columns. Specifying path information with qualified object attributes (your second suggestion) also works. So everything works, I didn't Is this approach correct for cases where you end up

[sqlalchemy] Re: 0.5.2, orm, deferring joined columns during query construction

2009-03-14 Thread Michael Bayer
On Mar 13, 2009, at 6:41 PM, me wrote: Thanks for the help! Specifying path as a string relative to the root of the query properly defers the columns. Specifying path information with qualified object attributes (your second suggestion) also works. So everything works, I didn't Is

[sqlalchemy] Re: 0.5.2, orm, deferring joined columns during query construction

2009-03-12 Thread Michael Bayer
me wrote: 2] Using path to the joined column: query = query.option(defer(a.s1_relation.col1), defer (a.s1_alias_relation.col2),...) 2 Simply doesn't work for me (i.e. the columns i'm deferring are clearly in the echoed sql). try not putting a in there. defer() is based on an older