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