Re: selective statement logging

Bruce Momjian wrote:

>Andrew Dunstan wrote:
>
>
>>>Well, if it is parse error, then we can't know what type of command it
>>>really was. They could type 'SE9ECT 1' or 'SELECT 1 WH8RE x=1' and both
>>>are not really SELECT commands to me.
>>>
>>>
>>>
>>>
>>>
>>If I delay logging until after the parse, these log lines would come out
>>in reverse order. Not sure if that matters to anyone, but it might annoy
>>me slightly.
>>
>>line:3 LOG: statement: se4dt ddd;
>>line:4 ERROR: syntax error at or near "se4dt" at character 1
>>
>>
>
>Sure you sure? I didn't think you would get a tag on a syntax error, so
>no log would print, which I think is OK.
>
>
>
If people are happy with suppressing statement logging on a parse error,
OK. For the remainder I would just defer the logging till immediately
after the parse and get the tags for the statements - and suppress
logging the query string if they were all SELECT or all
SELECT|INSERT|UPDATE|DELETE|COPY according to the setting.

cheers

andrew