Hello, There's a DELETE query that will catch them in the notes of http://www.dbmail.org/mantis/view.php?id=305
Alternately wait just a little bit and it should be fixed right in dbmail-util. On Tue, 2006-07-11 at 14:46 -0400, Niblett, David A wrote: > Humm... Ok, then I guess the time for panic is now. Are > you saying that I likely have a lot of orphaned message blocks > that dbmail-util isn't finding? > > How might I find these so I can remove them from my database. > I'm assuming a large join of non-existant mailboxes, and > then finding which messages are attached to those. > > -- > David A. Niblett | email: [EMAIL PROTECTED] > Network Administrator | Phone: (352) 334-3400 > Gainesville Regional Utilities | Web: http://www.gru.net/ > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Paul J Stevens > Sent: Tuesday, July 11, 2006 3:37 AM > To: DBMail mailinglist > Subject: Re: [Dbmail] Delete accounts > > > > > Niblett, David A wrote: > > Sorry, I didn't remember, that I did create a foreign key constraint > > on a new column in dbmail_aliases connecting it back to user_idnr. > > > > By adding that column, I was able to retain complete functionality. > > Now I admit that my internal requirement is that you can't have an > > dbmail_alias entry if you don't have a dbmail_users entry. I made a > > placeholder user and tie all my standalone aliases to it. I suppose I > > > could have used user_idnr #1 (the internal user), but that doesn't > > seem like a good idea. > > > > As for the messages, I think that is also removed (this is v2.0.10). > > > > CREATE TABLE dbmail_messages ( > > ... > > mailbox_idnr INT8 REFERENCES dbmail_mailboxes(mailbox_idnr) > > ON DELETE CASCADE, > > physmessage_id INT8 REFERENCES dbmail_physmessage(id) > > ON DELETE CASCADE, > > ... > > David, > > You're reading this the wrong way. The statement above says that if you > delete a physmessage all associated messages are deleted. Deleting > messages does *not* affect related physmessages. > > > > > > > Since the dbmail_messages keys to the dbmail_mailboxes, and to > > dbmail_physmessages (same with dbmail_messageblks), I believe that it > > will cascade all the way down. > > No it doesn't. And that's a known bug (#305). > > > > > When I delete a user, I never see any orphaned blocks when I run > > dbmail-util. > > Because it turns out dbmail-util does not check for them properly; > contrary to my earlier statement. > -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
