pl/R problem
От | Don Isgitt |
---|---|
Тема | pl/R problem |
Дата | |
Msg-id | 44EB761E.4030505@soundenergy.com обсуждение исходный текст |
Ответы |
Re: pl/R problem
|
Список | 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
В списке pgsql-general по дате отправления: