From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Petr Vodicka <vodicka(dot)petr(at)email(dot)cz> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Debugging grayed out even pldebugger is installed in postgres |
Date: | 2009-08-03 10:02:19 |
Message-ID: | 937d27e10908030302h6e9eba3dgb944e4f8e1cd766a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2009-08-03 11:55:15 | Re: Debugging grayed out even pldebugger is installed in postgres |
Previous Message | Dave Page | 2009-08-03 09:46:35 | Re: Debugging grayed out even pldebugger is installed in postgres |