Hi, 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
param_patch.diff
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers