2007/9/4, korry.douglas <[EMAIL PROTECTED]>: > > > > 1. can be integrated into psql? > > There is an API - I wouldn't want to try to use it from the command-line, > but you certainly can. You would call functions such as: > SELECT * FROM pldbg_set_breakpoint( 'myfunction' ); > SELECT * FROM pldbg_wait_for_breakpoint( ... ); > SELECT * FROM pldbg_step_into( ... ); > SELECT * FROM pldbg_continue( .. .); > .... > Since it is driven by an API, you can code up a user interface in whatever > language/environment you like.
I tested it without success. I didn't find documentation. There is some startup sequence, so pldbg functions raised errors. > > 2. can be started from query execution (with breakpoint). Now I have > to expliciltly start debugged function. > > I'm not quite sure what you mean there. The debugger works in two > different modes: > > > 1) In-context debugging: you set a breakpoint on a function (from within a > tool like pgAdmin) and then invoke that function from some other client > application I mean method 1. I hadn't success with pgAdmin. Breakpoints was ignored. > > 2) Direct debugging: you set a breakpoint on a function and the debugger > invokes that function on your behalf. > > In pgAdmin, you start an in-context debugging by choosing the "Set > Breakpoint" (or perhaps "Set Global Breakpoint") option and you start a > direct debugging session by choosing the "Debug Function" option (sorry, I > don't have a copy of pgAdmin in front of me so I may have the spelling wrong > in there somewhere). > > -- Korry > I'll test it again in new beta pgAdmin Pavel ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match