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...