Re: Can't load plpgsql.so error [SOLVED] - Mailing list pgsql-general

From Adrian Urquhart
Subject Re: Can't load plpgsql.so error [SOLVED]
Date
Msg-id FVr0OMs0+2W=Asp1x=8b8uh6qzfd@4ax.com
Whole thread Raw
In response to Re: Can't load plpgsql.so error  (Ed Loehr <eloehr@austin.rr.com>)
List pgsql-general
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...


pgsql-general by date:

Previous
From: Jeffrey
Date:
Subject: Re: Perl error: fetchrow_hashref failed
Next
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: create rule x as on select...do insert - when?