Hi

It seems dbmail-smtp uses wrong quoting.
Since we started using postgresql-8.2 it started logging:


WARNING:  nonstandard use of \\ in a string literal
LINE 1: ..., messageblk,blocksize, physmessage_id) VALUES (1,'Return- Pa...
                                                            ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING:  nonstandard use of \\ in a string literal
LINE 1: ..., messageblk,blocksize, physmessage_id) VALUES (0,'The origi...
                                                            ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
Processed Message 1
All Done!

It seems the queries have a ' quoted with only 1 \ which needs to be doubled as in \\'


Marc

Reply via email to