Re: [GENERAL] PostgreSQL nonstandard use of escape in a string literal

2009-09-17 Thread Peter Eisentraut
On fre, 2009-09-18 at 14:05 +1000, Johnson, Trevor wrote: > Using Moodle with PostgreSQL 8.4 and we get warning messages... > > 2009-09-18 13:48:11 ESTWARNING: nonstandard use of escape in a string > literal at character 209 > > 2009-09-18 13:48:11 ESTHINT: Use the escape string syntax for > es

Re: [GENERAL] PostgreSQL nonstandard use of escape in a string literal

2009-09-17 Thread Jeff Davis
On Fri, 2009-09-18 at 14:05 +1000, Johnson, Trevor wrote: > Are these just warnings or is there something we need to fix? They are just warnings. The application is apparently written assuming the non-standard quoting for string literals. > If so is it okay to turn the warnings with escape_string

[GENERAL] PostgreSQL nonstandard use of escape in a string literal

2009-09-17 Thread Johnson, Trevor
Using Moodle with PostgreSQL 8.4 and we get warning messages... 2009-09-18 13:48:11 ESTWARNING: nonstandard use of escape in a string literal at character 209 2009-09-18 13:48:11 ESTHINT: Use the escape string syntax for escapes, e.g., E'\r\n'. "standard_conforming_strings" is set to off, i