PostgreSQL 9.0 中的 pl/pgsql 调试是否损坏,或者只是我的问题?
在升级到 9.0 之前的某个时间,我让调试器在 pgAdminIII 中工作,但现在我似乎无法使用 通常步骤。我相信这可能与 DLL 未正确加载有关,因为以下查询:
LOAD '$libdir/plugins/plugin_debugger.dll';
show shared_preload_libraries;
...返回空白行。 DLL 存在,如果我更改加载字符串,它会抱怨,所以我很确定它找到 DLL 没问题,但没有成功加载它。 show local_preload_libraries
返回相同的内容。
有什么想法吗?
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这只是我。我一直在不小心选择非 plpgsql 函数。当然,这个名字恰如其分的调试器并不对 SQL 或 plperl 函数进行操作……
我的脸都红了。[/dilbertquote]
It's just me. I had been carelessly selecting non-
plpgsql
functions the whole time. Of course, the aptly-named debugger does not operate onSQL
orplperl
functions...Boy is my face red.[/dilbertquote]