Search Postgresql Archives

Re: Logging queries that are part of a stored procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 9/8/06, Michael Nolan <htfoot@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux