Thread: log_statement not working on pl/pgsql functions

log_statement not working on pl/pgsql functions

From
"Fernando Moreno"
Date:
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?


Re: log_statement not working on pl/pgsql functions

From
Bruce Momjian
Date:
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. +