On Fri, May 16, 2008 at 1:32 PM, Robert Fitzpatrick <lists@webtent.net> wrote:
> I have built posgresql 8.3.1 on a FreeBSD 6.1 via the ports system
> WITH_DEBUG=true and also on a Windows machine with the debugger
> selected. I see the plugin_debugger.dll under the lib/plugins folder on
> the Windows machine as well. But when I look for the procs, they are not
> there....
>
> template1=# select * from pg_proc where proname like 'pldbg%';
> proname | pronamespace | proowner | prolang | procost | prorows | proisagg | prosecdef | proisstrict | proretset |
provolatile| pronargs | prorettype | proargtypes | proallargtypes | proargmodes | proargnames | prosrc | probin |
proconfig| proacl
>
---------+--------------+----------+---------+---------+---------+----------+-----------+-------------+-----------+-------------+----------+------------+-------------+----------------+-------------+-------------+--------+--------+-----------+--------
> (0 rows)
>
> Can someone help or point me to some docs that can tell me what else I
> need to do to enable debugging plpgsql?
There is a README with the plugin which tells you how to modify
postgresql.conf to preload the libraries at server start (which you
must do). Once you've done that, just run the pldbgapi.sql script
that's also included to load the api functions into the database you
wish to debug.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com