log_statement not working on pl/pgsql functions
Hi, I've changed the setting log_statement to mod, in order to log data
modifications, and it's working fine with sentences sent by the client
application (psql included), but insert/update/delete sentences executed
inside functions are not logged. Functions are called in a select query.
I've reloaded (even restarted) the server, the line with the setting is
uncommented and "show log_statement" returns "mod". I changed its value to
"all" for a while and it worked as expected, logging every single query. By
the way, I'm using Postgresql 8.3.1 on window xp.
Am I doing something wrong?
Fernando Moreno wrote:
Hi, I've changed the setting log_statement to mod, in order to log data
modifications, and it's working fine with sentences sent by the client
application (psql included), but insert/update/delete sentences executed
inside functions are not logged. Functions are called in a select query.I've reloaded (even restarted) the server, the line with the setting is
uncommented and "show log_statement" returns "mod". I changed its value to
"all" for a while and it worked as expected, logging every single query. By
the way, I'm using Postgresql 8.3.1 on window xp.Am I doing something wrong?
The problem is that the checks for the statement type are done at the
time the query arrives from the client, not while executing in a
function.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +