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