The following issue has been SUBMITTED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=698
======================================================================
Reported By: maximP
Assigned To:
======================================================================
Project: DBMail
Issue ID: 698
Category: IMAP daemon
Reproducibility: random
Severity: minor
Priority: normal
Status: new
target:
======================================================================
Date Submitted: 13-May-08 08:04 CEST
Last Modified: 13-May-08 08:04 CEST
======================================================================
Summary: PostgreSQL 8.3.1 can't execute query
Description:
During some user's IMAP activity, dbmail writes to log:
Error:[sql] dbpgsql.c,db_query(+287): query failed [SELECT message_idnr
FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id
JOIN dbmail_datefield d ON d.physmessage_id=p.id WHERE mailbox_idnr= 210
AND status IN (0,1) AND TO_DATE(datefield,'YYYY-MM-DD') <
TO_DATE('2008-04-29 00:00:00',
'YYYY-MM-DD') ORDER BY message_idnr]
: [ERROR: function to_date(timestamp without time zone, unknown) not
exists LINE 1: ...d WHERE mailbox_idnr= 210 AND status IN (0,1) AND
TO_DATE(da...
^ HINT: No function matches the given name and argument types. You might
need to add explicit type casts. ]
Why do we need such cast: TO_DATE(datefield,'YYYY-MM-DD') ?
======================================================================
Issue History
Date Modified Username Field Change
======================================================================
13-May-08 08:04 maximP New Issue
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
