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
>
The permissions were chown'ed to root.root
I've changed them to postgres.postgres.
It still gave me the same error. Do I need to stop the postmaster and
restart it?
All of the other files in /usr/local/pgsql/lib are owned by root.root.
Should they be owned by postgres.postgres?
Thanks
Andy