Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PLpgSQL Stat Problem

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-28 14:23:53
Message-ID: Pine.LNX.4.05.9904280921240.22733-100000@tmg.themecca.net (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

Responses

pgsql-general by date

Next:From: Jim MercerDate: 1999-04-28 14:41:17
Subject: Re: [GENERAL] PLpgSQL Stat Problem
Previous:From: Oleg BroytmannDate: 1999-04-28 13:57:47
Subject: Re: [GENERAL] PLpgSQL Stat Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group