Re: selective statement logging

Bruce Momjian wrote:

>Andrew Dunstan wrote:
>
>
>>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?
>>
>>
>
>Yes, look at how the command tag is grabbed for the PS display, and do
>the log checks at that point.
>
>
>
Yes, I thought about that. But it would delay the logging of statements,
and I'm not sure that's a good idea. What would happen on parse errors,
for example?

cheers

andrew