On Donnerstag 10 September 2009 Michael Monnerie wrote: > PostgreSQL 8.3 issue
Interesting, I got this answer from a PG dev: ************ There has *never* been a Postgres release that accepted bytea ILIKE something. I'm not sure what you were really doing before, but that wasn't it. ************ So, this is the query you posted stripped down: SELECT k.messageblk FROM dbmail_messageblks k WHERE k.messageblk ILIKE '%multipart/encrypted%'; He's right, that query doesn't work on PG 8.1 either. How did you make dbmail run such a query? Looks like via a search, but I guess that never worked and would be a bug then. So please, how can I reproduce that query? 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 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
