I can't get the pgadmin debugger to work. I found this thread and it is
the same symptom I have. I went through the staeps, and I have the same
plugins that the original poster had. But I don't understand the
suggestions on how to fix it. Can someone please clarify?
In my case, I have a database that I created from scratch, not using
dump/restore. I also tried creating a simple function in the "postgres"
database and I cannot debug that either. What "debugger functions" are
you referring to? What is "template0"? (I see it in pgadmin but I
can't connect to it so I don't know what that is. I also have a
"template1").
>
> On Feb 4, 2008 4:13 PM, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
> > Hi all,
> >
> > As the subject line says..... I've downloaded PG 8.3 (Win32) and
> > included the pl/pgsql debugger in the installation options; I've also
> > upgraded PgAdmin to 1.8.2. I checked that the debugger files were
> there,
> > and they are - C:\Program Files\PostgreSQL\8.3\lib\plugins contains
> > plugin_debugger.dll and plugin_profiler.dll; and I even added this
> > folder to the PATH.
> >
> > However, Tools -> Debugging remains greyed out, and the "Debug" items
> > which the help says ought to appear on the contect menu for functions
> > isn't there.
> >
> > What am I missing?
>
> Are you trying to debug a function that isn't written in pl/pgsql?
> Also, make sure the debugger functions are loaded in the database you
> wish to debug - if you've restored a dump into a database created form
> template0, they might not be (there should be an sql script in the
> server's share directory).
Any suggestions?