SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-10-2008, 02:06 PM
| ||||
| ||||
 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? -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support      |
|
05-12-2008, 09:09 AM
| ||||
| ||||
| Re: Can't get the debugger going 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support |
 |
« Enum input support with drop-down list when editing a table
|
Regarding the LDAP connection string. »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
All times are GMT. The time now is 05:38 PM.
