On Oct 27, 2008, at 4:23 PM, GustaV wrote:
> > Ok it looks good... > > I assume it also means I can't rely on ON DELETE CASCADE anymore, and > I then must use passive_deletes=False. > At least on those relations. I dont see why that's the case here. It depends on the specific scenario, but in the example I gave, the parent row is deleted and all the child rows - the UPDATE statement is moot. You could modfiy the OnFlushExt to call a different hook for deleted objects, though. > In a general point of view, using MySQL InnoDB tables, is ON DELETE > CASCADE more efficient than SA stuff? much more efficient and you should keep using it. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---