Re: cannot get Debugger to install on 9.2 on Win7 x-64

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 10:38:54
Message-ID: CAJAxBQHRm8GrquH-N48vf_a76wTPmo_8XR-c8=_wd3Yq2=t08w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2013-02-07 10:39:34 Re: ESC closes window without warning
Previous Message Michal Kozusznik 2013-02-07 10:20:48 Re: ESC closes window without warning