On Donnerstag 10 September 2009 David Young wrote: > Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[sql] > dbpgsql.c,db_query(+287): query failed [SELECT m.message_idnr, > v.header value, k.messageblk FROM dbmail_messageblks k JOIN > dbmail_physmessage p ON k.physmessage_id=p.id JOIN dbmail_messages m > ON m.physmessage _id=p.id JOIN dbmail_headervalue v ON > v.physmessage_id=p.id WHERE m.mailbox_idnr=53 AND m.status in (0,1) > HAVING SUBSTRING(v.headervalue ,0,255) ILIKE '%multipart/encrypted%' > OR k.messageblk ILIKE > '%multipart/encrypted%'] : [ERROR: operator does not exist: bytea > ~~* unkno wn > LINE 1: ...55) ILIKE '%multipart/encrypted%' OR k.messageblk ILIKE > '%mu... ^ HINT: No operator matches the given name and argument > type(s). You might need to add explicit type casts. > ] > > Sep 10 00:39:49 node1.the.matrix dbmail-imapd[4957]: Error:[mailbox] > dbmail-mailbox.c,mailbox_search(+1374): could not execute query
PostgreSQL 8.3 issue. They started to have tougher type casts. The message explains that "You might need to add explicit type casts.". I still don't have it, so I don't know exactly how to cast it. Maybe OR k.messageblk::varchar ILIKE '%multipart/encrypted%' would solve the problem, but you can't cast from bytea to varchar, at least in 8.2. Asking on the PostgreSQL list should help, I'll do that. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: wwwkeys.eu.pgp.net Key-ID: 1C1209B4
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail