Re: [Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-18 Thread Erik Osterman
Paul J Stevens wrote: Hrm... Well, since the first solution was satisfied without modifying any code, I'll probably just use a trigger to insert the deleted folders into a separate table. That might work if you break the constraint on the messages table against the mailboxes table. But

Re: [Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-18 Thread Erik Osterman
First, thanks for taking an interest in this discussion. It wasn't my intention to shape a whole new feature, if it hadn't been proposed before. That said, I'd be delighted if it were to make its way into the mainline. Paul J Stevens wrote: - make sure mailboxes are re-assigned when a user

Re: [Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-16 Thread Erik Osterman
Paul J Stevens wrote: message deletion can be dealt with by *not* running 'dbmail-util -py'. In that case message status will be kept at 2, being invisible to the daemons, but still there in the database. Yes, this exactly what I want. Would be the process of restoring the emails?

Re: [Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-16 Thread Erik Osterman
Paul J Stevens wrote: message deletion can be dealt with by *not* running 'dbmail-util -py'. In that case message status will be kept at 2, being invisible to the daemons, but still there in the database. To restore an email, is it as simple as setting the status back to 1 and setting the

[Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-14 Thread Erik Osterman
. Best, Erik Osterman ___ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Re: [Dbmail-dev] Paranoid DELETEs / Archiving

2008-01-14 Thread Erik Osterman
14, 2008 at 05:50:34AM -0800, Erik Osterman wrote: Hi, I'm looking for a way to keep all email ever received whether deleted or not. As it stands, I don't see that this is possible with dbmail. The reason is two fold: users frequently delete messages that need to be restored; we're legally