Currently, the SQL statement that causes an error condition is reported
in the server log. On the other hand, the bind-parameter is not reported
as following.
> FATAL: terminating connection due to administrator command
> STATEMENT: UPDATE tbl SET name = $1 WHERE id = $2
> LOG: shutting down
The bind-parameter is useful information for debugging. So, I made
the small patch which reports the bind-parameter together with
the SQL statement on an error.
> FATAL: terminating connection due to administrator command
> STATEMENT: UPDATE tbl SET name = $1 WHERE id = $2
> DETAIL: parameters: $1 = 'hoge', $2 = '1'
> LOG: shutting down
Any comments welcome!
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
No comments:
Post a Comment