From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | Andy Lewis <alewis(at)themecca(dot)net> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] PLpgSQL Stat Problem |
Date: | 1999-04-28 13:57:47 |
Message-ID: | Pine.SOL2.3.96.SK.990428175610.25300A-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 28 Apr 1999, Andy Lewis wrote:
> I got the following error after trying to copy the example at:
> http://www.postgresql.org/mhonarc/pgsql-sql/1999-04/msg00076.html
>
> ----------------------------------------------------------
> test=> select a(pin,first_name) from ibs_subscriber ;
> ERROR: stat failed on file ${exec_prefix}/lib/plpgsql.so
> ----------------------------------------------------------
>
> The file plpgsql.so does exist in /usr/local/pgsql/lib.
> Any ideas?
What are permissions on the file plpgsql.so? Does postgres allowed
access to the file? Check it:
su - postgres
cat plpgsql.so > /dev/null
> Andy
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Lewis | 1999-04-28 14:23:53 | Re: [GENERAL] PLpgSQL Stat Problem |
Previous Message | Andy Lewis | 1999-04-28 13:42:57 | PLpgSQL Stat Problem |