[sqlalchemy] Query.update() and joins

2013-05-09 Thread Tobias Bieniek
Hi guys, I have stripped down my problematic code to the following: http://pastebin.com/AvvEr103 I am trying to call the Query.update() method on a query that is using an innerjoin to load some more information that I use in a filter. If I use the same expression to query data everything

Re: [sqlalchemy] Query.update() and joins

2013-05-09 Thread Michael Bayer
An explicit JOIN isn't supported within an UPDATE statement on the Postgresql platform, SQLAlchemy supports UPDATE..FROM but you need to set up the join condition as an implicit join, which is what mark_type_read2 is essentially doing, establishing the equality between Event and Notification