Aaron Stone wrote: > The original code assumes no foreign keys for purposes of cleaning up > disconnected message data. Your main query: > >> "DELETE FROM %smessages WHERE status=%d",DBPFX, >> MESSAGE_STATUS_PURGE); > > relies on foreign keys to remove the dependent data, or a subsequent run > of dbmail-util to clean out the disconnected parts. That's a totally > reasonable expectation on both counts -- Paul added foreign keys in the > 2.2 schemas, and if they're missing for some reason then dbmail-util > will clean out the leftover pieces later. > > IMHO, this is a reasonable change to make if Paul has time to review it.
agreed. Michael, plz file a bug report for this so I wont forget about this. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
