Debugging Server Code

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             :                 :
+---------------------------------------+-----------------+