Обсуждение: Can not debug plpgsql using PgAdminIII

I’m trying to debug plpgsql functions in PgAdmin using the integrated debugger but I can’t get a debug session to start. I right click on any plpgsql function and get the debugging context menu with both the “Debug” and “Set breakpoint” options, but neither of them works.

When I try the “Debug” option the parameters input dialog displays. However once I enter the parameter values and select OK, the function fully executes, I don’t go into a debug session, and the parameters input dialog pops up again.

When I try to debug using the “Set breakpoint” option, the debugger dialog loads and the “Waiting for target” starts. But when I execute that function from another query session nothing happens.

I have set the PgadminIII logging to ‘debug’ and here is what I get when I try to explicitly debug a function called bde.bde_get_app_specific():

2010-08-03 14:51:36 QUERY  : Set query (devgeo01:5432): SELECT count(*) AS count, proname FROM pg_proc WHERE oid = 3050079 GROUP BY proname

2010-08-03 14:51:36 INFO   : EDB libpq functions are not available.

2010-08-03 14:51:36 INFO   : worker thread waiting for some work to do...

2010-08-03 14:51:36 QUERY  : SET log_min_messages TO fatal

2010-08-03 14:51:36 QUERY  : select t.*,   pg_catalog.oidvectortypes( t.argtypes ) as argtypenames, t.argtypes as argtypeoids,  l.lanname, n.nspname, p.proretset, y.typname AS rettype from  pldbg_get_target_info( '3050079', 'o' ) t , pg_namespace n, pg_language l, pg_proc p, pg_type y where  n.oid = t.schema and   l.oid = t.targetlang and   p.oid = t.target and   y.oid = t.returntype

2010-08-03 14:51:36 QUERY  : SELECT version();

2010-08-03 14:51:39 QUERY  : SELECT count(*) FROM pg_proc WHERE proname = 'pldbg_get_proxy_info';

2010-08-03 14:51:39 QUERY  : SELECT proxyapiver FROM pldbg_get_proxy_info();

2010-08-03 14:51:39 QUERY  : select plpgsql_oid_debug(3050079);

2010-08-03 14:51:39 QUERY  : SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : Queueing: SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : 1 commands in queue

2010-08-03 14:51:39 INFO   : Executing: SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : Complete: PGRES_TUPLES_OK

2010-08-03 14:51:39 INFO   : OnTargetComplete() called

2010-08-03 14:51:39 INFO   : PGRES_TUPLES_OK

I think I have setup all of the required instrumentation on the server and have loaded the functions correctly. The shared libraries have been added to the server config:

shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll,$libdir/plugins/plugin_profiler.dll'

I have restarted the server and libraries have been loaded:

spi_db=# show shared_preload_libraries;

                        shared_preload_libraries

-------------------------------------------------------------------------

 $libdir/plugins/plugin_debugger.dll,$libdir/plugins/plugin_profiler.dll

(1 row)

I have installed support functions into the database with the plpgsql functions:

C:\Program Files\PostgreSQL\8.4\share\contrib>psql -U postgres spi_db < pldbgapi.sql

But I still can not get the debugger to work. It seems to me that debugger connection is not started at all.

I’m using PostgreSQL 8.4.2 compiled by Visual C++ build 1400 32-bit (installed using the EnterpriseDB one click installer) on Windows Server Standard 2003, and PgAdmin 1.10.5 on WinXP SP3. The apart from the changing the memory and connection parameters, the server config is as installed.

Thanks,

Late follow-up on this email!

Can anyone give any help? Has it been resolved in 1.12?

I’m trying to debug plpgsql functions in PgAdmin using the integrated debugger but I can’t get a debug session to start. I right click on any plpgsql function and get the debugging context menu with both the “Debug” and “Set breakpoint” options, but neither of them works.

When I try the “Debug” option the parameters input dialog displays. However once I enter the parameter values and select OK, the function fully executes, I don’t go into a debug session, and the parameters input dialog pops up again.

When I try to debug using the “Set breakpoint” option, the debugger dialog loads and the “Waiting for target” starts. But when I execute that function from another query session nothing happens.

I have set the PgadminIII logging to ‘debug’ and here is what I get when I try to explicitly debug a function called bde.bde_get_app_specific():

2010-08-03 14:51:36 QUERY  : Set query (devgeo01:5432): SELECT count(*) AS count, proname FROM pg_proc WHERE oid = 3050079 GROUP BY proname

2010-08-03 14:51:36 INFO   : EDB libpq functions are not available.

2010-08-03 14:51:36 INFO   : worker thread waiting for some work to do...

2010-08-03 14:51:36 QUERY  : SET log_min_messages TO fatal

2010-08-03 14:51:36 QUERY  : select t.*,   pg_catalog.oidvectortypes( t.argtypes ) as argtypenames, t.argtypes as argtypeoids,  l.lanname, n.nspname, p.proretset, y.typname AS rettype from  pldbg_get_target_info( '3050079', 'o' ) t , pg_namespace n, pg_language l, pg_proc p, pg_type y where  n.oid = t.schema and   l.oid = t.targetlang and   p.oid = t.target and   y.oid = t.returntype

2010-08-03 14:51:36 QUERY  : SELECT version();

2010-08-03 14:51:39 QUERY  : SELECT count(*) FROM pg_proc WHERE proname = 'pldbg_get_proxy_info';

2010-08-03 14:51:39 QUERY  : SELECT proxyapiver FROM pldbg_get_proxy_info();

2010-08-03 14:51:39 QUERY  : select plpgsql_oid_debug(3050079);

2010-08-03 14:51:39 QUERY  : SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : Queueing: SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : 1 commands in queue

2010-08-03 14:51:39 INFO   : Executing: SELECT * FROM bde.bde_get_app_specific('2743'::integer, 'SURV'::character varying, 'Y'::character)

2010-08-03 14:51:39 INFO   : Complete: PGRES_TUPLES_OK

2010-08-03 14:51:39 INFO   : OnTargetComplete() called

2010-08-03 14:51:39 INFO   : PGRES_TUPLES_OK

I think I have setup all of the required instrumentation on the server and have loaded the functions correctly. The shared libraries have been added to the server config:

shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll,$libdir/plugins/plugin_profiler.dll'

I have restarted the server and libraries have been loaded:

spi_db=# show shared_preload_libraries;

                        shared_preload_libraries

-------------------------------------------------------------------------

 $libdir/plugins/plugin_debugger.dll,$libdir/plugins/plugin_profiler.dll

(1 row)

I have installed support functions into the database with the plpgsql functions:

C:\Program Files\PostgreSQL\8.4\share\contrib>psql -U postgres spi_db < pldbgapi.sql

But I still can not get the debugger to work. It seems to me that debugger connection is not started at all.

I’m using PostgreSQL 8.4.2 compiled by Visual C++ build 1400 32-bit (installed using the EnterpriseDB one click installer) on Windows Server Standard 2003, and PgAdmin 1.10.5 on WinXP SP3. The apart from the changing the memory and connection parameters, the server config is as installed.

Thanks,