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

From Dave Page
Subject Re: Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me?
Date
Msg-id AANLkTinN5TQ+PHCHTZLYabGp7HV-iJwKgFqvw+VJeMEZ@mail.gmail.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 Wed, Nov 10, 2010 at 5:16 PM, Kevin Field <kevinjamesfield@gmail.com> wrote:
> Hi folks,
>
> I had the debugger working in pgAdminIII at one point, some time
> before upgrading to 9.0, but as of right now I can't seem to get it
> working using the usual steps. I believe it may have something to do
> with the DLL not loading correctly, because the following query:
>
> 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



-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgadmin-support by date:

Previous
From: Jan-Peter Seifert
Date:
Subject: Dependents show up twice?
Next
From: Guillaume Lelarge
Date:
Subject: Re: Dependents show up twice?