Skip site navigation (1) Skip section navigation (2)

Re: Debugging grayed out even pldebugger is installed in postgres

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 (view raw or flat)
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

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2009-08-03 11:55:15
Subject: Re: Debugging grayed out even pldebugger is installed in postgres
Previous:From: Dave PageDate: 2009-08-03 09:46:35
Subject: Re: Debugging grayed out even pldebugger is installed in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group