A NOTE has been added to this issue. ====================================================================== http://www.dbmail.org/mantis/view.php?id=899 ====================================================================== Reported By: hoshi Assigned To: ====================================================================== Project: DBMail Issue ID: 899 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 24-Apr-11 19:36 CEST Last Modified: 25-Apr-11 12:23 CEST ====================================================================== Summary: empty mails with postgresql 9.0 backend Description: dbmail.err entries in the form of: WARNING: nonstandard use of \\ in a string literal LINE 1: ..., messageblk,blocksize, physmessage_id) VALUES (1,'Received:... ^ HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
only found issue 0000862 today and did _not_ try "bytea_output = escape" no idea either if this is already "fixed" in 2.3 or 3.0 this seems to only affect the db_escape_binary function, which was modified to use the E'' escaping (in pgbackend) maybe you do have a use for it ====================================================================== ---------------------------------------------------------------------- (0003181) paul (administrator) - 25-Apr-11 12:23 http://www.dbmail.org/mantis/view.php?id=899#c3181 ---------------------------------------------------------------------- the empty messages are caused by the change in bytea handling in pg9. Workaround as described in http://www.dbmail.org/mantis/view.php?id=862. The string-escaping in 3.0 is a non-issue; only prepared statements are used except for a couple of trusted queries. In 2.2 all strings are escaped using calls in libpq. Are those deprecated since pg9? Issue History Date Modified Username Field Change ====================================================================== 24-Apr-11 19:36 hoshi New Issue 24-Apr-11 19:36 hoshi File Added: dbmail-2.2.17-bj1.patch 25-Apr-11 12:23 paul Note Added: 0003181 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev