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
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
