First I created a new user on dbmail with dbmail-user with the following options (-a -s -w -p MD5-HASH). DBMAIL created the new user/mailbox successfully.
Next, I created an IMAP mailbox using Outlook 2003 SP3. Connected to dbmail-imapd. Outlook showed a single mailbox (Inbox). I sent an email to the new mailbox. The error occurred when I selected the Inbox and the new message. David On Thu, Sep 10, 2009 at 8:23 AM, Michael Monnerie < [email protected]> wrote: > 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 > -- David
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
