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.
Also, I assume "modification statements" means insert/update/delete, or are we talking about DDL mods (like "alter table")?
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.
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
