[sqlalchemy] Re: SA trying to update read-only views in Postgres

2007-07-06 Thread Andreas Jung
Clear()ing the session before the mandatory commit resolved the issue (more a workaround than a solution :-). Andreas --On 6. Juli 2007 12:25:25 +0200 Andreas Jung [EMAIL PROTECTED] wrote: I have a self-referential mapper where a view is involved within a primaryjoin of a relation.

[sqlalchemy] Re: SA trying to update read-only views in Postgres

2007-07-06 Thread Michael Bayer
On Jul 6, 2007, at 6:25 AM, Andreas Jung wrote: I have a self-referential mapper where a view is involved within a primaryjoin of a relation. Traversing a tree represented through the mapper generates a bunch of UPDATE operations on the view (no idea why so far) although only SELECT

[sqlalchemy] Re: SA trying to update read-only views in Postgres

2007-07-06 Thread Michael Bayer
On Jul 6, 2007, at 6:25 AM, Andreas Jung wrote: I have a self-referential mapper where a view is involved within a primaryjoin of a relation. Traversing a tree represented through the mapper generates a bunch of UPDATE operations on the view (no idea why so far) although only SELECT

[sqlalchemy] Re: SA trying to update read-only views in Postgres

2007-07-06 Thread Andreas Jung
--On 6. Juli 2007 11:15:38 -0400 Michael Bayer [EMAIL PROTECTED] wrote: On Jul 6, 2007, at 6:25 AM, Andreas Jung wrote: I have a self-referential mapper where a view is involved within a primaryjoin of a relation. Traversing a tree represented through the mapper generates a bunch of