On Mon, May 2, 2011 at 1:32 PM, Robert Collins <[email protected]> wrote: > On Mon, May 2, 2011 at 6:24 PM, Stuart Bishop > <[email protected]> wrote: >> StructuralSubscription is referenced by BugSubscriptionFilter. >> BugSubscriptionFilter is referenced by BugNotificationFilter and 4 subtables. >> BugNotificationFilter is referenced by BugNotification >> BugNotification is referenced by Bug and Message >> >> Far too much fallout with all that cascading delete. >> >> I think we need to pull this patch until we can make the cleanup more >> intelligent. > > So when a SS goes, > - the filter should go > - the 4 subtables with filter details should go > - bugnotification contains pending not yet sent emails; they can go > - the message and bug that the notification is for Must Not go > > That seems doable with cascade delete ?
its easier - in my coffee lacking state, I reversed a relationship. BugNotificationFilter is not referenced by BugNotification, so we just need to cascade the BugSubscriptionFilter, the BugNotificationFilter and the 4 subtables already cascade. Preparing a patch now. -- Stuart Bishop <[email protected]> http://www.stuartbishop.net/ _______________________________________________ Mailing list: https://launchpad.net/~launchpad-dev Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-dev More help : https://help.launchpad.net/ListHelp
