Re: Can't load plpgsql.so error [SOLVED]

On 11 Apr 2000 23:52:32 -0400, eloehr(at)austin(dot)rr(dot)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...