Problem while debugging using PgAdmin

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.

Waiting for reply.

Thanks and Regards

Shanker N Srivastava

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(at)postgresql(dot)org]
Sent: Friday, October 26, 2007 8:56 PM
To: Shanker N Srivastava
Cc: pgadmin-support(at)postgresql(dot)org; korryd(at)enterprisedb(dot)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