Re: Debugging grayed out even pldebugger is installed in postgres

Again: Please keep messages on the mailing list.

On Mon, Aug 3, 2009 at 10:54 AM, Petr Vodicka<vodicka(dot)petr(at)email(dot)cz> wrote:
> 2009/8/3 Dave Page <dpage(at)pgadmin(dot)org>:
>> Please keep messages on the mailing list.
>>
>> On Mon, Aug 3, 2009 at 10:38 AM, Petr Vodicka<vodicka(dot)petr(at)email(dot)cz> wrote:
>>> Yes, I did. I have few my own pl/pgsql function in my database and
>>> some other from installed Pg::snaphost. And if I select any of these
>>> functions, still no debug.
>>
>> A few things to check:
>>
>> Are the functions owned by your user account? (or are you a superuser?).
> Debug functions are owned by postgres, my functions are owned by my
> user account and I am superuser.
>
>>
>> Do any of the debug options appear if you right-click the function?
> No.
>
>>
>> Are the debug API functions installed in the same database as the
>> functions you want to debug? Having them in the maintenance database
>> is not enough.
> Yes, they are. And in the maintenance database (postgres) too.

What does the SQL query:

show shared_preload_libraries;

return?

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com