From: | Tim Romano <tim(dot)romano888(at)gmail(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: cannot get Debugger to install on 9.2 on Win7 x-64 |
Date: | 2013-02-07 11:57:22 |
Message-ID: | CAJAxBQFO97_GD7TqKB7Wg5yX+AwfQ8GAEB8dEZmbTma7ZkCDyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Success.
One must go into the configuration in pgAdmin (Tools menu, Server
Configuration) and *enable* the shared_preload_libraries item by checking
the checkbox next to it, save the config, and then stop/restart the
database service.
Tim
On Thu, Feb 7, 2013 at 5:38 AM, Tim Romano <tim(dot)romano888(at)gmail(dot)com> wrote:
> Thanks for taking time to reply, Dave. I have stopped and restarted the
> service several times, and have opened and closed pgAdmin several times.
> It's definitely a PL/pgsql function. That's all I've been writing.
> language plpgsql
>
> Does the debugger definitely work on Windows 7 64-bit version?
>
> When I look at the treeview, under Extensions, there are three:
> adminpack
> pldbgapi
> plpgsql
>
> pldbgapi has OID 17717, the schema is public, it is relocatable, it's
> version 1.0, and comment says server-side support for debugging PL/pgSQL
> functions.
>
> It has these dependents:
> Type: breakpoint
> Type: frame
> Type: proxyinfo
> Type: targetinfo
> Type: var
>
> and 21 functions.
>
> I'm thinking it is a GUI issue. What does the UI look for when
> determining whether to display the Debugging option on Tools menu or on the
> treeview context menu?
>
> Regards
> Tim
>
>
>
>
>
>
>
>
> On Thu, Feb 7, 2013 at 3:53 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>> On Wed, Feb 6, 2013 at 7:58 PM, Tim Romano <tim(dot)romano888(at)gmail(dot)com>
>> wrote:
>> > I followed the steps to enable the debugger:
>> >
>> > 1. Modified the postgresql.conf file as directed
>> shared_preload_libraries =
>> > '$libdir/plugin_debugger.dll'
>> > 2. Stopped and restarted the database service.
>> > 3. Ran CREATE EXTENSION pldbgapi in the database where I'm writing the
>> > functions. It reported success.
>> >
>> > But the debug option does show up in the Tools menu, nor does it appear
>> in
>> > the treeview's context-menu when I right-click on a function-name.
>>
>> I'm sure people are getting sick of me saying this here, but it worked
>> for me! Some things to check:
>>
>> - Did you restart pgAdmin (or at least disconnect and reconnect the
>> server) after creating the extension?
>>
>> - The debugger only supports pl/pgsql functions on PostgreSQL. Are you
>> right-clicking a function written in a different language?
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2013-02-07 12:00:21 | Re: cannot get Debugger to install on 9.2 on Win7 x-64 |
Previous Message | Dave Page | 2013-02-07 11:37:02 | Re: ESC closes window without warning |