Re: PL/pgSQL Debugger Support

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Denis Lussier <denisl(at)enterprisedb(dot)com>, Alvaro Herrera <alvherre(at)surnet(dot)cl>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PL/pgSQL Debugger Support
Date: 2005-06-24 04:28:53
Message-ID: 200506240028.54466.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Thursday 23 June 2005 14:21, Josh Berkus wrote:
> Denis, all,
>
> > I got to thinking it¹d be kewl if PgAdmin3 supported an interactive
> > debugger for pl/pgsql.  If anyone¹s interested in expertly tackling such
> > a community project, with some financial sponsorship from EDB, please
> > contact me privately.
>
> Just FYI, EMS Hitech has a windows-only PL/pgSQL debugger. So it's
> apparently possible even with the current tech.
>

IIRC thier debugger is little more than BEGIN; SELECT foo(); ROLLBACK; which
isn't great as far as debuggers go.

> Overally, though, we'd want to support something command-line like the Perl
> debug shell. Then any tool could use it.

Uh... a lot of tools have issues executing stuff from the command line... what
we need is something sql driven, or at least that opeates at that level,
inside the db.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2005-06-24 04:31:41 Re: pl/pgsql: END verbosity
Previous Message ITAGAKI Takahiro 2005-06-24 04:16:44 Re: [PATCHES] O_DIRECT for WAL writes

Browse pgsql-patches by date

  From Date Subject
Next Message Robert Treat 2005-06-24 04:31:41 Re: pl/pgsql: END verbosity
Previous Message ITAGAKI Takahiro 2005-06-24 04:16:44 Re: [PATCHES] O_DIRECT for WAL writes