Mailing List Archive

[DBMail 0001091]: Dbmail Attachment
The following issue has been SUBMITTED.
======================================================================
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 11:20 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
======================================================================

Issue History
Date Modified Username Field Change
======================================================================
16-Nov-17 11:20 gokigoki New Issue
======================================================================

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail-dev
[DBMail 0001091]: Dbmail Attachment [ In reply to ]
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