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:
Show quoted text
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.
Show quoted text
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...