Обсуждение: debugging pgsql in pgadmin

<b>1. Environment</b><br /><br /> - postgresql 8.4.0 + plpgsql debugger<br /> - pgadmin III v.1.10.0 <br /><br />We
debugfunctions with pgadmin, and it is OK (including stepping into other functions, thanks for your help).<br /><br
/><b>2.Question</b><br /><br />The question is: suppose many pgsql functions with many arguments. Each time we need to
debuga function, we need to type all the parameters in the debug window. Is it possible to call a function in debug
modeotherwise? Can we anyway store this debug function call? Do we need to type the value of the parameters each
time?<br/><br />Suggestion would be adding the possibility of making a debug function call from a file, or somehow
beingable to save in a file this debug call..<br /><br />Regards.<br /><br /><br /> 

On Mon, Jul 6, 2009 at 3:57 PM, fatmijumar
fatmijumar<fatmijumar@gmail.com> wrote:
> 1. Environment
>
> - postgresql 8.4.0 + plpgsql debugger
> - pgadmin III v.1.10.0
>
> We debug functions with pgadmin, and it is OK (including stepping into other
> functions, thanks for your help).
>
> 2. Question
>
> The question is: suppose many pgsql functions with many arguments. Each time
> we need to debug a function, we need to type all the parameters in the debug
> window. Is it possible to call a function in debug mode otherwise? Can we
> anyway store this debug function call? Do we need to type the value of the
> parameters each time?

It should remember them if you debug the same function twice in
succession. It'll forget if you debug a different one though.

Another option is to set a global breakpoint on a function, and then
call it from a query window, or your application. The downside with
that is that it'll break on the first session which calls the
function, which may not be yours if there are multiple users on your
server (which is actually the whole point of global breakpoints of
course)!.


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com