Re: pl/R problem

From: Don Isgitt <djisgitt(at)soundenergy(dot)com>
To: Don Isgitt <djisgitt(at)soundenergy(dot)com>, Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: pl/R problem
Date: 2006-08-23 19:44:42
Message-ID: 44ECB02A.9060101@soundenergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:
> 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.
>
>
Quite so, Alvaro & Michael. Yes, world read as I said, but missing
execute at one level. Sorry for my carelessness. It works as expected now.

Thank you,

Don

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message andre 2006-08-23 19:45:56 How to detect Postgres deadlocks?
Previous Message barryc.ctr 2006-08-23 19:27:09 Can I read data load files without loading in db?