some aliasing is missing or what? see attached file
(sa 0.4)
print session.query( PVOwnership).join( 'param_value').all()
...
sqlalchemy.exceptions.OperationalError: (OperationalError) no such
column: ParamValue.db_id
u'SELECT "PVOwnership".param_value_id
AS "PVOwnership_param_value_id", "PVOwnership".which_owner
AS "PVOwnership_which_owner", "PVOwnership"._someowner_id
AS "PVOwnership__someowner_id", "PVOwnership".db_id
AS "PVOwnership_db_id" \n
FROM "PVOwnership" JOIN ("Model" JOIN "ParamValue"
ON "ParamValue".db_id = "Model".db_id)
ON "PVOwnership".param_value_id = "ParamValue".db_id ORDER
BY "PVOwnership".oid' []
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
a.py
Description: application/python
