Reporting the bind-parameter on an error

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Reporting the bind-parameter on an error
Дата
Msg-id 3f0b79eb0808150353r59a998f8i150ad5d49a94ebac@mail.gmail.com
обсуждение исходный текст
Ответы Re: Reporting the bind-parameter on an error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Guillaume Smet"
Дата:
Сообщение: Re: migrate data 6.5.3 -> 8.3.1
Следующее
От: Andreas Pflug
Дата:
Сообщение: Re: migrate data 6.5.3 -> 8.3.1