Обсуждение: plr installation
Hi,
im trying to install PL/R into postgresql, but im unable create function as normal user because the language is not trusted.
Is it possible to install plr as a trusted language instead of giving user superuser rights?
The message i get is this:
ERROR: permission denied for language plr
Here are pg_laguage records:
bioinf=> SELECT * from pg_language;
lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
----------+----------+---------+--------------+---------------+--------------+--------
internal | 10 | f | f | 0 | 2246 |
c | 10 | f | f | 0 | 2247 |
sql | 10 | f | t | 0 | 2248 |
plperl | 10 | t | t | 3709344925 | 3709344926 |
plpgsql | 10 | t | t | 3709344928 | 3709344929 |
plr | 10 | t | f | 3313675089 | 0 |
(6 rows)
lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | lanvalidator | lanacl
----------+----------+---------+--------------+---------------+--------------+--------
internal | 10 | f | f | 0 | 2246 |
c | 10 | f | f | 0 | 2247 |
sql | 10 | f | t | 0 | 2248 |
plperl | 10 | t | t | 3709344925 | 3709344926 |
plpgsql | 10 | t | t | 3709344928 | 3709344929 |
plr | 10 | t | f | 3313675089 | 0 |
(6 rows)
if i try to update lanpltrusted field in that table, can that produce some damage on database?
update pg_language set lanpltrusted=not( lanpltrusted ) where lanname='plr';
thanks in advance
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
On 12/29/2012 05:37 PM, Viktor Bojović wrote: > Hi, > > im trying to install PL/R into postgresql, but im unable create function > as normal user because the language is not trusted. > Is it possible to install plr as a trusted language instead of giving > user superuser rights? No. PL/R is untrusted because R gives access to system commands and the file system. No way around it at the moment, nor in the foreseeable future. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, & 24x7 Support