Hi, I have a table and a view mapped to objects as such :
class A(object): mapped to a table with a primary key column id with a onetomany attribute list_of_b, being a relation to all rows of B with a_id == self.id class B(object): mapped to a view with a column a_id being a reference to the id column of A Since B is mapped to a view, no updates should happen on B. So, in A, the list_of_b relation is configured with : passive_updates = True, passive_deletes = 'all', viewonly = True, cascade = False But whenever an object of A is deleted, sqlalchemy tries to update the a_id columns of all rows of B that were loaded in memory, which of course should not happen, since B is a view. I have tried various permutations of the possible relationship configurations, but without success. Is it possible to solve this ? Can one mark a table or even a column as non writable ? Thank you and best regards, Erik -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
