Thread: Can't load plpgsql.so error

Hi

I'm a Postgres newbie, so bear with me :o)

I've created a trigger, which calls a procedure written in plpgsql,
The trgiger is called on INSERT on a table. However, when I try to do
an insert on the table, using psql, I get a message saying that the
load of /usr/local/pgsql/lib/plpgsql.so failed because shared object
libpq.so.2 not found. Yet the very fact that I'm running psql means
that it was found...

Any hints, clues, docs. greatly appreciated.

The system is

FreeBSD 4.0-RELEASE
Postgres 6.5.3

I use ldconfig to set the search paths (using LD_LIBRARY_PATH didn't
help).

Thanks

Adrian

Would you mind posting the actual error text along with PGDATA settings?

Adrian Urquhart wrote:
>
> I've created a trigger, which calls a procedure written in plpgsql,
> The trgiger is called on INSERT on a table. However, when I try to do
> an insert on the table, using psql, I get a message saying that the
> load of /usr/local/pgsql/lib/plpgsql.so failed because shared object
> libpq.so.2 not found. Yet the very fact that I'm running psql means
> that it was found...

On 11 Apr 2000 23:52:32 -0400, eloehr@austin.rr.com (Ed Loehr) wrote:

>Would you mind posting the actual error text along with PGDATA settings?
>

Well, I was in the process of sending the information you asked for,
when I decided to do some extra investigating. The outcome was that
I'd screwed up - ldconfig was replacing all the libraries it had
discovered at boot time with what it found in the postgres ~/lib
directory.

I went to /etc/defaults/rc.conf and edited ldconfig_paths to include
postgres.

Adrian.

>Adrian Urquhart wrote:
>>
>> I've created a trigger, which calls a procedure written in plpgsql,
>> The trgiger is called on INSERT on a table. However, when I try to do
>> an insert on the table, using psql, I get a message saying that the
>> load of /usr/local/pgsql/lib/plpgsql.so failed because shared object
>> libpq.so.2 not found. Yet the very fact that I'm running psql means
>> that it was found...