| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |