Обсуждение: Can't get the debugger going

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?

On Fri, May 9, 2008 at 5:10 PM, William Garrison <postgres@mobydisk.com> wrote:
> 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?

The functions that make up the debugger API, contained in
pldbgapi.sql, normally found in the share directory of your
installation. If they're not present in your maintenance database, run
the SQL script in psql or pgAdmin to create them, then restart
pgAdmin.

> 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").

template0 is a completely empty database which may be cloned (using
pgAdmin or CREATE DATABASE) to make new, empty databases.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com