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

Reply via email to