The following bug has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/bug_view_advanced_page.php?bug_id=0000181 ====================================================================== Reported By: Eduardo Stern Assigned To: ====================================================================== Project: DBMail Bug ID: 181 Category: Database layer Reproducibility: always Severity: major Priority: normal Status: new ====================================================================== Date Submitted: 13-Mar-05 07:12 CET Last Modified: 13-Mar-05 07:12 CET ====================================================================== Summary: Error in SQL using SuSE Linux 9, max value for int8 is exceeded, PostgreSQL 8 + Postfix Description: When using SuSE Linux 9, DBMAIL sends a bad insert command, with the max value of message_idnr:
Mar 11 19:41:30 dbxslave dbmail/imap4d[3933]: dbpgsql.c, db_query: Error executing query [SELECT seen_flag, answered_flag, deleted_flag, flagged_flag, draft_flag, recent_flag, TO_CHAR(internal_date, 'YYYY-MM-DD HH24:MI:SS' ), rfcsize, message_idnr FROM dbmail_messages msg, dbmail_physmessage pm WHERE pm.id = msg.physmessage_id AND message_idnr BETWEEN '1' AND '18446744073709551615' AND mailbox_idnr = '1' AND status < '2' ORDER BY message_idnr ASC] : [ERROR: value "18446744073709551615" is out of range for type bigint ] ====================================================================== Bug History Date Modified Username Field Change ====================================================================== 13-Mar-05 07:12Eduardo Stern New Bug ======================================================================