subject:"\[sqlalchemy\] joinedload alias"

[sqlalchemy] joinedload alias

2010-05-21 Thread jose soares

Hi all, I'm trying to use joinedload('specie') in a query but it makes an unexpected alias of table name to 'specie_1' and it conflict with passed orderby column specie.descrizione, as in: ProgrammingError: ('(ProgrammingError) invalid reference to FROM-clause entry for table specie\nLINE

Re: [sqlalchemy] joinedload alias

2010-05-21 Thread Michael Bayer

this looks like: http://www.sqlalchemy.org/trac/wiki/FAQ#ImusinglazyFalsetocreateaJOINOUTERJOINandSQLAlchemyisnotconstructingthequerywhenItrytoaddaWHEREORDERBYLIMITetc.whichreliesupontheOUTERJOIN On May 21, 2010, at 9:56 AM, jose soares wrote: Hi all, I'm trying to use