Re: [GENERAL] PLpgSQL Stat Problem

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@earthling.net
           Programmers don't die, they just GOSUB without RETURN.