pl/R problem

From: Don Isgitt <djisgitt(at)soundenergy(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pl/R problem
Date: 2006-08-22 21:24:46
Message-ID: 44EB761E.4030505@soundenergy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

Information first:

gds2=# select version();

version

----------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
20030502 (Red Hat Linux 3.2.3-20)
(1 row)

pl/R 0.6.2

R.2.3 (compiled from source)

R_HOME is defined (before starting postmaster)

gds2=# select * from pg_language;
lanname | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
-----------+---------+--------------+---------------+--------------+--------
internal | f | f | 0 | 2246 |
c | f | f | 0 | 2247 |
sql | f | t | 0 | 2248 |
plpgsql | t | t | 16393 | 16394 |
plperl | t | t | 18064 | 18065 |
plpythonu | t | f | 18067 | 0 |
plperlu | t | f | 18064 | 18065 |
plr | t | f | 24576 | 0 |

Now, for the problem:

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 the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Relevant server log piece:

cannot find system Renviron
Fatal error: unable to open the base package

LOG: server process (PID 6792) exited with exit code 2

So, the question: what am I missing that enables it to find the "Renviron"

Thank you.

Don

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-22 21:26:54 Re: varchar(n) vs. varchar
Previous Message Tom Lane 2006-08-22 21:24:10 Re: error msg when pg_restore