Обсуждение: Statement logging per connection

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.

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