Andrew Dunstan wrote: > I wrote: > > > > > > > If nobody is working on this I am prepared to look at it: > > > > . Allow logging of only data definition(DDL), or DDL and modification > > statements > > > > > > Here are some options: > > 1. change the type of "log_statement" option from boolean to string, > with allowed values of "all, mod, ddl, none" with default "none". > 2. same as 1. but make boolean true values synonyms for "all" and > boolean false values synonyms for "none". > 3. keep "log_statement" option as now and add a new option > "log_statement_level" with the same options as 1. but default to "all", > which will have no effect unless "log_statement" is true.
I like 1. > Also, I assume "modification statements" means insert/update/delete, or Yes. > are we talking about DDL mods (like "alter table")? Alter is DDL. > Finally, what about functions that have side effects? It would be nice > to be able to detect the statements to be logged at the syntactic level, > but it strikes me that that might not be possible. Not possible. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html