The following issue has been RESOLVED.
======================================================================
http://www.dbmail.org/mantis/view.php?id=698
======================================================================
Reported By: maximP
Assigned To: paul
======================================================================
Project: DBMail
Issue ID: 698
Category: IMAP daemon
Reproducibility: random
Severity: minor
Priority: normal
Status: resolved
target:
Resolution: fixed
Fixed in Version: 2.2.11
======================================================================
Date Submitted: 13-May-08 08:04 CEST
Last Modified: 14-Jul-08 11:01 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') ?
======================================================================
----------------------------------------------------------------------
paul - 14-Jul-08 11:01
----------------------------------------------------------------------
applied patch by Alan Hodgson
Issue History
Date Modified Username Field Change
======================================================================
13-May-08 08:04 maximP New Issue
14-Jul-08 11:01 paul Note Added: 0002587
14-Jul-08 11:01 paul Assigned To => paul
14-Jul-08 11:01 paul Status new => resolved
14-Jul-08 11:01 paul Resolution open => fixed
14-Jul-08 11:01 paul Fixed in Version => 2.2.11
======================================================================
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
