Re: selective statement logging - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: selective statement logging
Date
Msg-id 404F7655.8090509@dunslane.net
Whole thread Raw
In response to Re: selective statement logging  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: selective statement logging
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Ramanujam H S Iyengar"
Date:
Subject: How to get RelationName ??
Next
From: Tom Lane
Date:
Subject: Re: Timing of 'SELECT 1'