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