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

Re: Debug PostgreSQL function using pgAdmin

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Ken Chan <kenchanmc(at)gmail(dot)com>
Cc: pgadmin-support-request(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org
Subject: Re: Debug PostgreSQL function using pgAdmin
Date: 2011-10-24 21:01:39
Message-ID: 1319490099.2828.113.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgadmin-support
On Mon, 2011-10-24 at 01:42 +0800, Ken Chan wrote:
> I refer this (
> http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html)
>  to enable the debugger in the PostgreSQL server in order to debugging the
> plpgsql function by stepping through the codes using the pgadmin.
> 
> I have already set shared_preload_libraries =
> '$libdir/plugins/plugin_debugger.dll' in the postgresql.conf, run
> pldbgapi.sql , and restarted the server.
> 
> These steps should have been run successfully and plugin_debugger.dll should
> be loaded successfully as can be verified by using the command show
> shared_preload_libraries, and I can see the debugging option in the context
> menu with a right click on a function in pgAdmin.
> 
> When choosing "Debugging" --> Debug, a window pops up to allow me to enter
> the values for the input parameters. But after that, when I press OK, it
> does not respond at all.
> 
> Any ideas or did I miss something in the setup of the debugger on the
> server??
> 

Nope, seems you did it the right way.


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-10-24 21:20:39
Subject: Re: Minor bug, keyboard navigation
Previous:From: Guillaume LelargeDate: 2011-10-24 20:54:37
Subject: Re: ForeignTable->select bug report.

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