Thread: Logging queries that are part of a stored procedure

Logging queries that are part of a stored procedure

From
"Michael Nolan"
Date:
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?
--
Mike Nolan

Re: Logging queries that are part of a stored procedure

From
"Merlin Moncure"
Date:
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