Re: plperl user function - Mailing list pgsql-interfaces

From Korry
Subject Re: plperl user function
Date
Msg-id 1114103246.7513.19.camel@sakai
Whole thread Raw
In response to Re: plperl user function  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-interfaces
<blockquote type="CITE"><pre>
<font color="#000000">> Another question:  Is there an issue with using the untrusted perl language? </font>

<font color="#000000">IIRC you have to be a postgresql superuser (postgres) to execute an </font>
<font color="#000000">untrusted language function.</font>
</pre></blockquote><br /> I think you meant "<font color="#000000">you have to be a postgresql superuser to
</font><fontcolor="#000000"><i><u>create</u></i></font><font color="#000000"> an untrusted language function". 
</font>IIRC,<font color="#000000">a normal user can </font><font color="#000000"><i>execute</i></font><font
color="#000000">a function written in an untrusted language (assuming that s/he holds the proper EXECUTE privileges),
butonly a cluster superuser can </font><font color="#000000"><i>create</i></font><font color="#000000"> a function
writtenin an untrusted language.  Otherwise, it would be difficult to create a trigger in an untrusted language.
</font><br/><br />         -- Korry  

pgsql-interfaces by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: plperl user function
Next
From: "Keith Worthington"
Date:
Subject: Re: plperl user function