Обсуждение: Problem while debugging using PgAdmin

Shanker N Srivastava wrote:
> Hello,
> 
> I am using PsotgreSQL version 8.2.5, and using pl/pgsql Debugger for
> debugging my pl/pgsql functions. My pgAdmin version is also pgAdmin III
> v1.8.0,  while debugging I am getting below error
>  
>
==========================================================================================================================
> An error has occurred:
>  
> ERROR:  could not load library "/usr/local/pgsql/lib/pldbgapi.so":
> /usr/local/pgsql/lib/pldbgapi.so: undefined symbol: BreakpointInsert
>
> My database server is on linux, and my pgAdmin is on win
>
==========================================================================================================================
>
> I am just thinking, is it not working because, My database server is
> linux machine and pgAdmin is on windows XP machine, and are in different
> machine.
> 

That should not matter - the client and the server need not be the same
machine, or even the same platform/architecture.

How did you install the debugger plugin - did you find a package from
somewhere or build it yourself from source? Do $PGLIB/pldbgapi.so and
$PGLIB/plugins/plugin_debugger.so both exist, and did you successfully
run the pldbgapi.sql script in your database?

Regards, Dave

Hello Dave,

Thanks for your email. 

We downloaded from http://pgfoundry.org/projects/edb-debugger , and followed
the instructions given README file. Yes, both the files exist as you said.

I manually droped all the objects which was in the pldbgapi.sql, and
re-created them, now I am able to debug.

We will come back to you incase of other problems.

-Regards
Shanker
-----Original Message-----
From: Dave Page [mailto:dpage@postgresql.org] 
Sent: Friday, October 26, 2007 8:56 PM
To: Shanker N Srivastava
Cc: pgadmin-support@postgresql.org; korryd@enterprisedb.com
Subject: Re: [pgadmin-support] Problem while debugging using PgAdmin

Shanker N Srivastava wrote:
> Hello,
> 
> I am using PsotgreSQL version 8.2.5, and using pl/pgsql Debugger for
> debugging my pl/pgsql functions. My pgAdmin version is also pgAdmin III
> v1.8.0,  while debugging I am getting below error
>  
>
============================================================================
==============================================
> An error has occurred:
>  
> ERROR:  could not load library "/usr/local/pgsql/lib/pldbgapi.so":
> /usr/local/pgsql/lib/pldbgapi.so: undefined symbol: BreakpointInsert
>
> My database server is on linux, and my pgAdmin is on win
>
============================================================================
==============================================
>
> I am just thinking, is it not working because, My database server is
> linux machine and pgAdmin is on windows XP machine, and are in different
> machine.
> 

That should not matter - the client and the server need not be the same
machine, or even the same platform/architecture.

How did you install the debugger plugin - did you find a package from
somewhere or build it yourself from source? Do $PGLIB/pldbgapi.so and
$PGLIB/plugins/plugin_debugger.so both exist, and did you successfully
run the pldbgapi.sql script in your database?



Regards, Dave