A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1091 ====================================================================== Reported By: gokigoki Assigned To: ====================================================================== Project: DBMail Issue ID: 1091 Category: Database layer Reproducibility: N/A Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 16-Nov-17 11:20 CET Last Modified: 16-Nov-17 19:58 CET ====================================================================== Summary: Dbmail Attachment Description: Hello,
We have a dbmail 3.2.0 with PostgreSQL as a backend database. Currently, we have received a request to delete ALL attachments and ONLY attachments older than X year. So, we were wondering on how we could do this, and if it is possible at all. Spent some time looking for a solution, but with no avail. Is it possible to delete only the attachment from an email without affecting the email? Which database tables should we look at? Thank you in advance. Looking forward to any replies. Kind regards, Goran ====================================================================== ---------------------------------------------------------------------- (0003795) KBrown (reporter) - 16-Nov-17 19:58 http://www.dbmail.org/mantis/view.php?id=1091#c3795 ---------------------------------------------------------------------- Tables dbmail_physmessage, dbmail_partlists and dbmail_mimeparts Issue History Date Modified Username Field Change ====================================================================== 16-Nov-17 11:20 gokigoki New Issue 16-Nov-17 19:58 KBrown Note Added: 0003795 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail-dev
