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 по дате отправления: