From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: log options |
Date: | 2010-09-24 13:34:54 |
Message-ID: | BLU0-SMTP90877A98238AF6A468DBAAAC620@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tom Lane wrote:
> Frank Bax <fbax(at)sympatico(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | lalebarde | 2010-09-24 13:59:15 | Re: psql -c "select * from a-user-name-that-exist fails |
Previous Message | Josh Kupershmidt | 2010-09-24 13:34:03 | Re: psql -c "select * from a-user-name-that-exist fails |