pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Statement logging per connection
2+ messages / 2 participants
[nested] [flat]

* Statement logging per connection
@ 2005-07-18 10:08  KÖPFERL Robert <robert.koepferl@sonorys.at>
  0 siblings, 1 reply; 2+ messages in thread

From: KÖPFERL Robert @ 2005-07-18 10:08 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Statement logging per connection
@ 2005-07-21 14:50  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: KÖPFERL Robert <robert.koepferl@sonorys.at>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2005-07-21 14:50 UTC (permalink / raw)
  To: KÖPFERL Robert <robert.koepferl@sonorys.at>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-07-21 14:50 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-18 10:08 Statement logging per connection KÖPFERL Robert <robert.koepferl@sonorys.at>
2005-07-21 14:50 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox