Andrew Dunstan wrote: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?
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.
cheers
andrew
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
