Обсуждение: 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: > > 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. >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...