The following issue has been REOPENED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=305 ====================================================================== Reported By: variable Assigned To: ====================================================================== Project: DBMail Issue ID: 305 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: feedback ====================================================================== Date Submitted: 28-Feb-06 23:04 CET Last Modified: 01-Mar-06 21:36 CET ====================================================================== Summary: Deletion of user refuses to delete mail Description: When I delete a user either through dbmail-util or just though phppgadmin the phymessage and messageblks for that users message still exist, the message, alias, and mailbox have all been deleted. If I run dbmail-users -e <user> then dbmail-users -d <user> then it works as it should. This has been the same on both 2.0.7 and 2.0.9 on postgresql. ======================================================================
---------------------------------------------------------------------- paul - 01-Mar-06 10:45 ---------------------------------------------------------------------- This is a feature, not a bug. There are no relational constraints on the mail-storage tables (physmessage, messageblks). This is because physmessages can be shared between more than one mailbox/user. ---------------------------------------------------------------------- variable - 01-Mar-06 21:36 ---------------------------------------------------------------------- But shouldnt dbmail-util detect unattached mail and delete it? Because it does not do this. Issue History Date Modified Username Field Change ====================================================================== 28-Feb-06 23:04 variable New Issue 01-Mar-06 10:45 paul Note Added: 0001015 01-Mar-06 10:45 paul Status new => resolved 01-Mar-06 10:45 paul Resolution open => no change required 01-Mar-06 21:36 variable Status resolved => feedback 01-Mar-06 21:36 variable Resolution no change required => reopened 01-Mar-06 21:36 variable Note Added: 0001017 ======================================================================
