Thread: Escape string tracing

I have a system that's been giving the nonstandard use of \\...' warning
in the postgresql log.  Is there a way to get the SQL associated with
the warning without logging all the sql statements being processed?

Mike Blackwell wrote:
> I have a system that's been giving the nonstandard use of \\...' warning
> in the postgresql log.  Is there a way to get the SQL associated with
> the warning without logging all the sql statements being processed?

Yes, mark it as an escape string, E''. See the documentation and release
notes.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Mike Blackwell написа:
> I have a system that's been giving the nonstandard use of \\...' warning
> in the postgresql log.  Is there a way to get the SQL associated with
> the warning without logging all the sql statements being processed?


Yes, set "log_min_error_statement" to "WARNING"
(http://www.postgresql.org/docs/current/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN).


--
Milen A. Radev