Thread: 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?
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. +