Thread: Debugging Server Code
I'm guessing that there is no step-wise debugger for pgsql. If there is, then glory be and call me a dummy for not R'ing TFM. In fact, I've never heard of a step-wise debugger for any DB server, am I wrong? As I grovel through some plPerl code in a statement level trigger that depends on an array of variables, I wonder if the lack of such a debugger can be considered one of the biggest impediments to larger adoption of server-side code. I don't mean to be facetious here, how many serious and powerful programmers do you know who don't depend heavily on a good debugger to step through the code and find the nasty parts? Anyway, just a thought. We now return to our regularly scheduled mailing list...
Kenneth Downs wrote: > I'm guessing that there is no step-wise debugger for pgsql. If there > is, then glory be and call me a dummy for not R'ing TFM. > In fact, I've never heard of a step-wise debugger for any DB server, am > I wrong? > > As I grovel through some plPerl code in a statement level trigger that > depends on an array of variables, I wonder if the lack of such a > debugger can be considered one of the biggest impediments to larger > adoption of server-side code. I don't mean to be facetious here, how > many serious and powerful programmers do you know who don't depend > heavily on a good debugger to step through the code and find the nasty > parts? Every one that properly uses server side code ;) > Anyway, just a thought. It certainly would be great. IIRC there is actually one for plpgsql over at pgfoundry. Joshua D. Drake > > We now return to our regularly scheduled mailing list... > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/ > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
Kenneth Downs wrote: > I'm guessing that there is no step-wise debugger for pgsql. If there > is, then glory be and call me a dummy for not R'ing TFM. > > In fact, I've never heard of a step-wise debugger for any DB > server, am I wrong? > Yes. I've done step-wise debugging in Oracle (PL/SQL) and MS-SQL Server. MySQL even has it. For PostgreSQL, in addition to the pgfoundry solution Joshua mentioned, there's also a debugger from Enterprise DB: http://www.enterprisedb.com/products/enterprisedb_debugger.do
> ------- Original Message ------- > From: "Adam Rich" <adam.r@sbcglobal.net> > To: "'Kenneth Downs'" <ken@secdat.com> > Sent: 14/03/07, 20:06:46 > Subject: Re: [GENERAL] Debugging Server Code > > For PostgreSQL, in addition to the pgfoundry solution Joshua mentioned, > there's also a debugger from Enterprise DB: > > http://www.enterprisedb.com/products/enterprisedb_debugger.do The next major version of pgAdmin will also include the native (ie. non-java) version of the debugger client. Regards, Davd
On 14/03/2007 20:26, Dave Page wrote: > The next major version of pgAdmin will also include the native (ie. > non-java) version of the debugger client. Fantastic! When d'you think it might be out? Is it available in a development version to play with yet? Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
> ------- Original Message ------- > From: "Raymond O'Donnell" <rod@iol.ie> > To: "'pgsql general'" <pgsql-general@postgresql.org> > Sent: 14/03/07, 20:51:33 > Subject: Re: [GENERAL] Debugging Server Code > > On 14/03/2007 20:26, Dave Page wrote: > > > The next major version of pgAdmin will also include the native (ie. > > non-java) version of the debugger client. > > Fantastic! When d'you think it might be out? In time for 8.3. > Is it available in a > development version to play with yet? No. Hiroshi is currently migrating the code into our tree. There's a fair bit to be done yet. Regards, Dave
On Wed, 14 Mar 2007 12:56:25 -0700, "Joshua D. Drake" <jd@commandprompt.com> wrote: > It certainly would be great. IIRC there is actually one for plpgsql over > at pgfoundry. Do you remember what it's called? In the search for plpgsql I get pgflows, plpsm, and enterprise db's debugger (which the summary says requires enterprise db 8.1.4 or wait for 8.3 if the patch is submitted/accepted) The only one I've seen is do it is EMS SQL Manager for a mere $275. klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@kgb.une.edu.au : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+