Zitat von [EMAIL PROTECTED]: > Hi, I've found this odd thing. > > All selects have this "ROW_NUMBER() OVER (ORDER BY rowid ASC) AS ora_rn" in > them. > > I found that when using inheritance mapping, and the resulting select joins > over > two tables, oracle tells me: "ORA-00918: column ambigously defined". > > When I patch this in OracleCompiler.visit_select (line 216 in > database/oracle.py): > orderby = "%s.rowid ASC" % select.froms[0].name
This is what is now really working for me. table = select.froms[0] if hasattr(table, 'name'): name = table.name else: name = table.id orderby = "%s.rowid ASC" % name ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
