During some recent testing I was getting:
'WARNING: nonstandard use of \\ in a string literal'
'HINT: Use the escape string syntax for backslashes, e.g., E'\\'.'
I believe the query in question was not updated since PgSQL 7 times.
Patch attached, not heavily tested as I do not use PgSQL in prod
On 06/12/2013 11:56 AM, Chris Moules wrote:
> During some recent testing I was getting:
> 'WARNING: nonstandard use of \\ in a string literal'
> 'HINT: Use the escape string syntax for backslashes, e.g., E'\\'.'
>
> I believe the query in question was not updated since PgSQL 7 times.
>
> Patch
On 12/06/13 12:53, Tom Hendrikx wrote:
> On 06/12/2013 11:56 AM, Chris Moules wrote:
>> During some recent testing I was getting: 'WARNING: nonstandard
>> use of \\ in a string literal' 'HINT: Use the escape string
>> syntax for backslashes, e.g., E'\\'.'
>>
>> I believe the query in question
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.
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-bu
On 12/06/13 14:51, Chris Moules wrote:
>
> Could it be that postgres is built with "escape_string_warning = on" ?
Just downloaded the source of postgres.
I found this in the HISTORY file when grep'ing for escape_string_warning
Migration to Version 8.2
...
* Set escape_string_warning to on
