A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1039 ====================================================================== Reported By: ALyarskiy Assigned To: ====================================================================== Project: DBMail Issue ID: 1039 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 24-Jan-14 09:39 CET Last Modified: 24-Jan-14 13:58 CET ====================================================================== Summary: Insert of relation between physmessage, header name and header value does not check already existing relations. Description: Postgres log contains errors: ERROR: duplicate key value violates unique constraint "dbmail_header_pkey"
Full log attached. ====================================================================== ---------------------------------------------------------------------- (0003629) paul (administrator) - 24-Jan-14 13:58 http://www.dbmail.org/mantis/view.php?id=1039#c3629 ---------------------------------------------------------------------- this will only happen if a message has duplicate headers. That just doesn't seem to justify the added roundtrip for an additional query. Issue History Date Modified Username Field Change ====================================================================== 24-Jan-14 09:39 ALyarskiy New Issue 24-Jan-14 09:39 ALyarskiy File Added: headers_duplicate_keys.postgres.log 24-Jan-14 13:58 paul Note Added: 0003629 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev