Thread: Debug PostgreSQL function using pgAdmin
I refer this (http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html) to enable the debugger in the PostgreSQL server in order to debugging the plpgsql function by stepping through the codes using the pgadmin.
I have already set shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' in the postgresql.conf, run pldbgapi.sql , and restarted the server.
These steps should have been run successfully and plugin_debugger.dll should be loaded successfully as can be verified by using the command show shared_preload_libraries, and I can see the debugging option in the context menu with a right click on a function in pgAdmin.
When choosing "Debugging" --> Debug, a window pops up to allow me to enter the values for the input parameters. But after that, when I press OK, it does not respond at all.
Any ideas or did I miss something in the setup of the debugger on the server??
I am using PostgreSQL 8.3 on window XP and pgAdmin 1.14.
For more information including the screen captures , please refer to my questions at
Thanks and best regards,
Ken
On Mon, 2011-10-24 at 01:42 +0800, Ken Chan wrote: > I refer this ( > http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html) > to enable the debugger in the PostgreSQL server in order to debugging the > plpgsql function by stepping through the codes using the pgadmin. > > I have already set shared_preload_libraries = > '$libdir/plugins/plugin_debugger.dll' in the postgresql.conf, run > pldbgapi.sql , and restarted the server. > > These steps should have been run successfully and plugin_debugger.dll should > be loaded successfully as can be verified by using the command show > shared_preload_libraries, and I can see the debugging option in the context > menu with a right click on a function in pgAdmin. > > When choosing "Debugging" --> Debug, a window pops up to allow me to enter > the values for the input parameters. But after that, when I press OK, it > does not respond at all. > > Any ideas or did I miss something in the setup of the debugger on the > server?? > Nope, seems you did it the right way. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com