Re: Logging queries that are part of a stored procedure - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Logging queries that are part of a stored procedure
Date
Msg-id b42b73150609081924t68d6fb3bw41bd05a0ff053c33@mail.gmail.com
Whole thread Raw
In response to Logging queries that are part of a stored procedure  ("Michael Nolan" <htfoot@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Michael Nolan"
Date:
Subject: Logging queries that are part of a stored procedure
Next
From: aBBISh
Date:
Subject: find a free database design software