Re: selective statement logging

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: selective statement logging
Дата
Msg-id 200403102344.i2ANifo21372@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: selective statement logging  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: selective statement logging  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
> > If people are happy with suppressing statement logging on a parse error, 
> > OK.
> 
> I think that's a really, really awful idea.  Not infrequently, the
> postmaster log is the easiest way of debugging applications that are
> sending bogus SQL.  If you fail to log the bogus SQL then you've just
> cut debuggers off at the knees.
> 
> I haven't read the earlier part of the thread yet so I don't know just
> what problem you want to solve, but please not this solution.

The issue is allowing only logging of DDL statements, or DDL and data
modification statements, as listed on the TODO list.  If they ask for
all statements, certainly we should log all statements.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


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

Предыдущее
От: Jonathan Gardner
Дата:
Сообщение: Re: How to get RelationName ??
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: selective statement logging