Re: Logging queries that are part of a stored procedure

On 9/8/06, Michael Nolan <htfoot@gmail.com> wrote:
> Setting postgresql 8.1.3 to log all queries only logs direct queries,
> not ones made as part of a stored procedure (function) call.
>
> Is there a way to get it to log queries that are part of functions?

not really, but you can 'raise notice' inside pl/pgsql functions or
(as a last resort) insert records into a log table.  in between
statement executions.

merlin