Re: [GENERAL] pl/R problem

2006-08-23 Thread Joe Conway
Don Isgitt wrote: 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. Ah, good to know. I'll add myself a todo to eliminate the crash in this scenario. I will include a fix in the next release, which wi

Re: [GENERAL] pl/R problem

2006-08-23 Thread Don Isgitt
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 115

Re: [GENERAL] pl/R problem

2006-08-23 Thread Michael Fuhr
On Wed, Aug 23, 2006 at 09:37:17AM -0500, Don Isgitt wrote: > Michael Fuhr wrote: > >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

Re: [GENERAL] pl/R problem

2006-08-23 Thread Alvaro Herrera
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 >

Re: [GENERAL] pl/R problem

2006-08-23 Thread Don Isgitt
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

Re: [GENERAL] pl/R problem

2006-08-23 Thread Don Isgitt
Adam Witney wrote: Don Isgitt wrote: Michael Fuhr wrote: On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote: gds2=# create function sd(_float8) returns float as '' language 'plr'; CREATE FUNCTION gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8); se

Re: [GENERAL] pl/R problem

2006-08-23 Thread Michael Fuhr
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

Re: [GENERAL] pl/R problem

2006-08-23 Thread Joe Conway
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. I use R quite a lot, so I know

Re: [GENERAL] pl/R problem

2006-08-23 Thread Don Isgitt
Michael Fuhr wrote: On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote: gds2=# create function sd(_float8) returns float as '' language 'plr'; CREATE FUNCTION gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8); server closed the connection unexpectedly This p

Re: [GENERAL] pl/R problem

2006-08-22 Thread Michael Fuhr
On Tue, Aug 22, 2006 at 04:24:46PM -0500, Don Isgitt wrote: > gds2=# create function sd(_float8) returns float as '' language 'plr'; > CREATE FUNCTION > > gds2=# select round(sd('{1.23,1.31,1.42,1.27}'::_float8)::numeric,8); > server closed the connection unexpectedly >This probably means