From: | Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | plr installation |
Date: | 2012-12-30 01:37:58 |
Message-ID: | CAJu1cLb=EHE+e1xUj+L+s+oTzdbvh-W-cqLnsfPd9bDhRDQ4Xg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2012-12-30 02:19:35 | Re: plr installation |
Previous Message | Michael O'Donnell | 2012-12-28 14:45:03 | checksum error messages when using md5 |