Config option log_statement

From: S Murthy Kambhampaty <smk_va(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Config option log_statement
Date: 2005-05-14 23:00:45
Message-ID: 20050514230045.6150.qmail@web51009.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-patches

In postgresql 8.0, "create table <> as ..." statements
appear not to logged unless log_statement = 'all' in
postgresql.conf. We are trying to reduce noise in the
logs from pgAdminIII and phpPgAdmin, but we use a lot
of 'create table <> as ...' queries that need to be
logged, and their duration tracked. Is there a
combination of settings that will do the trick? Can
postgresql be upgraded to log "create table <> as ..."
statements with log_statment = 'ddl' and/or
log_statment = 'mod'?

Thanks,
Murthy


__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomaz Borstnar 2005-05-14 23:00:59 Re: IMPORTANT: two new PostgreSQL security problems found
Previous Message S Murthy Kambhampaty 2005-05-14 22:50:23 Re: PGDG RPMS and integer-datetimes support

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-05-15 00:27:01 Re: [GENERAL] pgsql config flag update: apple rendezvous renamed bonjour
Previous Message Tom Lane 2005-05-14 21:57:52 Re: Exec statement logging