Re: PostgreSQL nonstandard use of escape in a string literal - Mailing list pgsql-general

From Jeff Davis
Subject Re: PostgreSQL nonstandard use of escape in a string literal
Date
Msg-id 1253247114.22589.26.camel@jdavis
Whole thread Raw
In response to PostgreSQL nonstandard use of escape in a string literal  ("Johnson, Trevor" <trevor.johnson@tafensw.edu.au>)
List pgsql-general
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_warning =
> off ?

I recommend you inform the authors of the application that they should
update it to use standard-conforming string literals. Then, you can turn
"escape_string_warning = off" to suppress the warnings while you are
waiting for them to fix it.

Regards,
    Jeff Davis



pgsql-general by date:

Previous
From: "Johnson, Trevor"
Date:
Subject: PostgreSQL nonstandard use of escape in a string literal
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL nonstandard use of escape in a string literal