Thread: Is pl/pgsql debugging broken in PostgreSQL 9.0, or is it just me?
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. Any ideas? Thanks, Kev
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
Never mind, I had been selecting non-plpgsql functions. :# Sorry about that. Thanks for your time and patience. Kev
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