pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStatement 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>
2005-07-21 14:50 ` Re: Statement logging per connection Bruce Momjian <pgman@candle.pha.pa.us>
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-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>
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