From: | Andy Lewis <alewis(at)themecca(dot)net> |
---|---|
To: | phd2(at)earthling(dot)net |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] PLpgSQL Stat Problem |
Date: | 1999-04-29 02:14:01 |
Message-ID: | Pine.LNX.4.05.9904282113170.30781-100000@tmg.themecca.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Postgres is allowed to access that file. No error message on the:
cat plpgsql.so > /dev/null
Andy
On Wed, 28 Apr 1999, Oleg Broytmann wrote:
> 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 | Michael J Davis | 1999-04-29 04:18:34 | RE: [GENERAL] LIMIT QUESTION |
Previous Message | Martin Wong | 1999-04-29 02:07:20 | LIMIT QUESTION |