Re: PostgreSQL nonstandard use of escape in a string literal

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: "Johnson, Trevor" <trevor(dot)johnson(at)tafensw(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL nonstandard use of escape in a string literal
Date: 2009-09-18 04:11:54
Message-ID: 1253247114.22589.26.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2009-09-18 04:24:14 Re: PostgreSQL nonstandard use of escape in a string literal
Previous Message Johnson, Trevor 2009-09-18 04:05:54 PostgreSQL nonstandard use of escape in a string literal