[HACKERS] selective statement logging

[Andrew Dunstan]

The TODO list contains this item which I said I would look at:

 Allow logging of only data definition(DDL), or DDL and modification 
statements

The trouble I see is that we currently do statement logging before we 
have examined the query string at all, in the code shown below from 
src/backend/tcop/postgres.c.

I guess I could construct one or more regexes to examine the query 
string, although that might affect performance a bit (of course, I would 
precompile the patterns).

Any other ideas on how to proceed?

cheers

andrew



List *
pg_parse_query(const char *query_string)
{
   List       *raw_parsetree_list;
   if (log_statement)
       ereport(LOG,
               (errmsg("statement: %s", query_string)));
   if (log_parser_stats)
       ResetUsage();
   raw_parsetree_list = raw_parser(query_string);

   if (log_parser_stats)
       ShowUsage("PARSER STATISTICS");
   return raw_parsetree_list;
}
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org