Обсуждение: log options

Is there a log option that will display the SQL statement triggering
WARNING; without having to log *all* queries?

2010-09-22 11:18:27 EDT WARNING:  nonstandard use of escape in a string
literal at character 59
2010-09-22 11:18:27 EDT HINT:  Use the escape string syntax for escapes,
e.g., E'\r\n'.

By any wild chance, is your system running old Crystal Reports reports?
Our product includes several reports, many of which were developed in
previous versions of CR, and our Postgres logs are packed with error
messages like that.

RobR


-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Frank Bax
Sent: Thursday, September 23, 2010 6:37 AM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] log options

Is there a log option that will display the SQL statement triggering
WARNING; without having to log *all* queries?

2010-09-22 11:18:27 EDT WARNING:  nonstandard use of escape in a string
literal at character 59
2010-09-22 11:18:27 EDT HINT:  Use the escape string syntax for escapes,
e.g., E'\r\n'.

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Frank Bax <fbax@sympatico.ca> writes:
> Is there a log option that will display the SQL statement triggering
> WARNING; without having to log *all* queries?

I think you want to set log_min_error_statement to warning.

            regards, tom lane

Tom Lane wrote:
> Frank Bax <fbax@sympatico.ca> writes:
>> Is there a log option that will display the SQL statement triggering
>> WARNING; without having to log *all* queries?
>
> I think you want to set log_min_error_statement to warning.


Nice idea; except it does not work.  I tested it with this statement:

testing=> select '\r\n';
WARNING:  nonstandard use of escape in a string literal
LINE 1: select '\r\n';
                ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
  ?column?
----------
  \r

(1 row)

I'd like to see SQL in log; but log file contains only:
2010-09-24 09:31:48 EDT mcl mcl WARNING:  nonstandard use of escape in a
string literal at character 8
2010-09-24 09:31:48 EDT mcl mcl HINT:  Use the escape string syntax for
escapes, e.g., E'\r\n'.

I did restart backend after changing postgresql.conf

Frank