Re: Logging conflicted queries on deadlocks

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Logging conflicted queries on deadlocks
Дата
Msg-id 26439.1206238910@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Logging conflicted queries on deadlocks  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Logging conflicted queries on deadlocks
Re: Logging conflicted queries on deadlocks
Список pgsql-patches
I wrote:
>>>> One thing that I worried about for a little bit is that you can imagine
>>>> privilege-escalation scenarios.

> A conservative approach would be to report the query texts *only* in the
> server log and never to the client --- this would need a bit of klugery
> but seems doable.

Anybody have any opinions about changing this or sticking with the
behavior as-submitted?  It doesn't seem like an open-and-shut issue
to me.

If we report the query texts only to the server log, we could remove all
restrictions on which users' queries would be reported.  That would
clearly be helpful in some cases.  On the other hand, it would clearly
be less convenient to use than the existing approach that sends
information to the client.  I'm not real excited about adding still
another wart to ereport() to make this possible, either.

Comments welcome.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: tuplestore_putvalues()
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Logging conflicted queries on deadlocks