Re: debugging pgsql in pgadmin

On Mon, Jul 6, 2009 at 3:57 PM, fatmijumar
fatmijumar<fatmijumar(at)gmail(dot)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