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
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? |