On Apr 16, 2008, at 6:21 PM, David Harrison wrote:
> > If I use "delete, delete-orphan" I get the same errors Like I mentioned, "delete-orphan" doesn't work very well separated from "delete" cascade - which means that its only appropriate for a one-to-many or one-to-one relation. When many "Friendship" rows reference the same "Dog" row, the deletion of any "Friendship" row cascades to the "Dog" row (since delete cascade is implied by delete- orphan cascade) and the constraint fails. "delete-orphan" was never designed to track many parents, its just a convenience feature for the typical "owned by one parent" use case. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
