Re: pl/R problem

Don Isgitt wrote:
> Michael Fuhr wrote:
> >On Wed, Aug 23, 2006 at 08:38:01AM -0500, Don Isgitt wrote:
> >
> >>Thanks for the reply and the research. The relevant file is
> >>
> >>[djisgitt(at)prs1 R-2.3.0]$ ls -l $R_HOME/etc/Renviron
> >>-rw-rw-r-- 1 djisgitt djisgitt 1151 Jun 1 11:42
> >>/home/djisgitt/R-2.3.0/etc/Renviron
> >>
> >>so I don't see that as the problem.
> >>
> >
> >Have you checked the permissions on all of the directories in the
> >file's path? Have you verified that PostgreSQL is using the same
> >$R_HOME? You can check the environment with plr_environ():
> >
> >
> Yes. At least world read all the way.

The best way to make sure this is the case I've found is

su - postgres
stat /home/djisgitt/R-2.3.0/etc/Renviron
(or ls, whatever)

I've seen people swearing they have world access all the way and then
noticing they are missing a little bit somewhere.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support