Re: Has anyone tried out the PL/pgSQL debugger?

On Sep 4, 2007, at 8:55 PM, korry.douglas wrote:

> Sorry about that John, there's a fix for this problem (it's an 8.2
> versus 8.3 issue) in the CVS repository. I thought I had rolled a
> new tarball after committing the fix but I guess not.
>
> You can pull the latest plugin_profiler.c from:

Thanks Korry, that fixed it.

Is there any documentation that describes how to use the SQL
functions? Some are obvious enough, but a simple example showing a
debugging session would be helpful.

In some simple tests it seems to work OK with pgAdmin (1.8b3) on OS
X. There appears to be a pgAdmin bug when you start a debug session
on a function that has no parameters:

ERROR: syntax error at or near ")"
LINE 1: SELECT * FROM myschema.myfunction)
^

Thanks for doing this project -- looks great.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL