The following issue has been SUBMITTED. ====================================================================== http://dbmail.org/mantis/view.php?id=595 ====================================================================== Reported By: cloos Assigned To: ====================================================================== Project: DBMail Issue ID: 595 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 17-May-07 14:51 CEST Last Modified: 17-May-07 14:51 CEST ====================================================================== Summary: Logs show error from pgsql due to duplicated assignmants Description: My .err log has a few entries like this in it:
Error query failed [UPDATE dbmail_messages SET recent_flag=0,seen_flag=1,answered_flag=0,deleted_flag=0,flagged_flag=0,draft_flag=0,recent_flag=0 WHERE message_idnr = 77 AND status < 2 AND mailbox_idnr = 3] : [ERROR: multiple assignments to same column "recent_flag" ] Error could not set flags At least with the pgsql backend dbmail should make sure it does not duplicate column names in SET queries. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 17-May-07 14:51 cloos New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev