selective statement logging
| От | Andrew Dunstan |
|---|---|
| Тема | selective statement logging |
| Дата | |
| Msg-id | 404F4F1A.8070502@dunslane.net обсуждение исходный текст |
| Ответы |
Re: selective statement logging
|
| Список | pgsql-hackers |
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;
}
В списке pgsql-hackers по дате отправления: