Hi Ive been testing slow statement logging on postgresql using searchs with kmail on my dbmail 2.2.11-rc1
It seems there is an error on postgres 8.3.1 for the following sentence: 2008-10-28 12:29:14 CET dbmail0 dbmail SENTENCIA: SELECT m.message_idnr, v.headervalue, 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=11 AND m.status in (0,1) HAVING SUBSTRING(v.headervalue,0,255) ILIKE '%angel%' OR k.messageblk ILIKE '%angel%' 2008-10-28 12:29:14 CET dbmail0 dbmail ERROR: el operador no existe: bytea ~~* "unknown" en carácter 344 2008-10-28 12:29:14 CET dbmail0 dbmail HINT: Ningún operador coincide con el nombre y el tipo de los argumentos. Puede desear agregar conversiones explícitas de tipos. I thnik this is just a Postgresql typecasting issue, but i let you now for safety. If you need proper english translation please tell me. Regards, Angel -- __________________________________________ Clist UAH __________________________________________ _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
