Re: [GENERAL] using plpgsql debuggers
On Wed, Oct 29, 2008 at 9:41 PM, Ravi Chemudugunta <[EMAIL PROTECTED]> wrote: > Thanks for the replies. > > I probably should have explained what it is that I am trying to do. > > I am trying to create a command line interface to the debugger rather than > using the GUI (that'll eventually plug into a sort of testing harness) - so > I am needing to figure out how it actually works. In the code comments it > mentions that any client can be used (psql) ... I don't mind all the extra > typing =) > > Any thoughts on how I may do this? > > I did have a brief look at the code inside pgadmin's debugger module - but > it was a bit hard to figure out how it kicked the whole process off... Ah, well that code is pretty complex to read as it uses async queries which fire events when they complete. There's no obvious flow to follow just by reading. My colleague posted an example of the API usage a while back - you can find it at http://archives.postgresql.org/pgsql-hackers/2007-09/msg00241.php -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] using plpgsql debuggers
Thanks for the replies. I probably should have explained what it is that I am trying to do. I am trying to create a command line interface to the debugger rather than using the GUI (that'll eventually plug into a sort of testing harness) - so I am needing to figure out how it actually works. In the code comments it mentions that any client can be used (psql) ... I don't mind all the extra typing =) Any thoughts on how I may do this? I did have a brief look at the code inside pgadmin's debugger module - but it was a bit hard to figure out how it kicked the whole process off... -ravi On Wed, Oct 29, 2008 at 9:54 PM, Dave Page <[EMAIL PROTECTED]> wrote: > On Wed, Oct 29, 2008 at 6:48 AM, Ravi Chemudugunta > <[EMAIL PROTECTED]> wrote: > > hi all, > > > > has anyone here heard of / used: > > > > http://pgfoundry.org/projects/edb-debugger/ > > > > This allows one to debug code, using breakpoints, single stepping etc. > which > > seems really great but I haven't figured out how to use it yet? > > > > I can't figure out how to invocate the server (target) side in order to > then > > get the proxy to connect to it. > > Run pgAdmin with the plugin enabled in your database, and right-click > a function and select one of the debugging options. > > > -- > Dave Page > EnterpriseDB UK: http://www.enterprisedb.com >
Re: [GENERAL] using plpgsql debuggers
On Wed, Oct 29, 2008 at 6:48 AM, Ravi Chemudugunta <[EMAIL PROTECTED]> wrote: > hi all, > > has anyone here heard of / used: > > http://pgfoundry.org/projects/edb-debugger/ > > This allows one to debug code, using breakpoints, single stepping etc. which > seems really great but I haven't figured out how to use it yet? > > I can't figure out how to invocate the server (target) side in order to then > get the proxy to connect to it. Run pgAdmin with the plugin enabled in your database, and right-click a function and select one of the debugging options. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] using plpgsql debuggers
hi all, has anyone here heard of / used: http://pgfoundry.org/projects/edb-debugger/ This allows one to debug code, using breakpoints, single stepping etc. which seems really great but I haven't figured out how to use it yet? I can't figure out how to invocate the server (target) side in order to then get the proxy to connect to it. Any help / suggestions much appreciated. -ravi