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) 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
