Re: Statement logging per connection

Поиск
Список
Период
Сортировка
Искать

Re: Statement logging per connection

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
K�PFERL Robert wrote:
> Hi,
> 
> is it possible to enable statement logging just for certain statements?
> 
> several tries with SET xxx to yyy
> resulted in messages like xx can't be set now?
> 
> When can it be set?

In 8.0 you can say:

	SET log_statement = 'mod';

-- 
  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, Pennsylvania 19073

Statement logging per connection

От:
KÖPFERL Robert <robert.koepferl@sonorys.at>
Дата:
Hi,

is it possible to enable statement logging just for certain statements?

several tries with SET xxx to yyy
resulted in messages like xx can't be set now?

When can it be set?


I intend to use that via an jdbc connection bu had a try in pgAdmin.
FAQ