Re: Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me? - Mailing list pgadmin-support

From Kevin Field
Subject Re: Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me?
Date
Msg-id d56abde9-1e97-4fc2-a0fb-1b70e8df3270@z20g2000pra.googlegroups.com
Whole thread Raw
In response to Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me?  (Kevin Field <kevinjamesfield@gmail.com>)
List pgadmin-support
On Nov 10, 5:00 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Wed, Nov 10, 2010 at 5:16 PM, Kevin Field <kevinjamesfi...@gmail.com> wrote:
> > LOAD '$libdir/plugins/plugin_debugger.dll';
> > show shared_preload_libraries;
>
> > ...returns a blank row. The DLL is present, and if I change the load
> > string, it complains, so I'm pretty sure it's finding the DLL okay,
> > but not successfully loading it. show local_preload_libraries returns
> > the same thing.
>
> LOADing the DLL won't make it show up there - you need to modify that
> config directive in postgresql.conf

Oops!  So...I added this to postgresql.conf:

shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'        #
(change requires restart)

...and restarted.  Now "show shared_preload_libraries" returns
"$libdir/plugins/plugin_debugger.dll", but the debugging options are
still greyed out in pgAdminIII.  All of the pldbg_* functions exist in
the schema I'm looking at.  What's next?

Thanks,
Kev


pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Dependents show up twice?
Next
From: Piotr Czekalski
Date:
Subject: PGAdmin - still no jobs node.