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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [8.1.4] Create index on timestamp fails
Следующее
От: Bryan White
Дата:
Сообщение: Re: share library version problems