Debug PostgreSQL function using pgAdmin

Поиск
Список
Период
Сортировка
От Ken Chan
Тема Debug PostgreSQL function using pgAdmin
Дата
Msg-id CAG=y6ZnzzTPAot==4CjPbxi7BJ-ivS4iX9nX7epKOpVQAUnwFg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Debug PostgreSQL function using pgAdmin  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
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

В списке pgadmin-support по дате отправления:

Предыдущее
От: sito-ito
Дата:
Сообщение: Query tool not open
Следующее
От: sito-ito
Дата:
Сообщение: Re: Query tool not open