On 12/06/13 14:18, Thomas Preud'homme wrote: > Le mercredi 12 juin 2013 14:10:25, Chris Moules a écrit : >> Hello Tom, >> >> System is a Debian 7 test system dspam: 3.10.2 - backport from >> testing postgresql: 9.1 >> >> The line that I patched is still in git HEAD as-is. I can look >> at re-building my full-debug version and posting full output. > > Strange, there is normally a patch (see attached file) to handle > this in Debian. > >> >> Regards, >> >> Chris > > Best regards, > > Thomas of the Debian Dspam team >
Hello Thomas, just found that. I had built with DEB_BUILD_OPTIONS="verbose_debug". Could it be that postgres is built with "escape_string_warning = on" ? A grep through /etc/postgresql: postgresql.conf:#escape_string_warning = on The Debian patch sets standard_conforming_strings to off. http://www.postgresql.org/docs/9.1/static/runtime-config-compatible.html <quote> escape_string_warning (boolean) When on, a warning is issued if a backslash (\) appears in an ordinary string literal ('...' syntax) and standard_conforming_strings is off. The default is on. Applications that wish to use backslash as escape should be modified to use escape string syntax (E'...'), because the default behavior of ordinary strings is now to treat backslash as an ordinary character, per SQL standard. This variable can be enabled to help locate code that needs to be changed. </quote> Chris ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel