Thread: Defining Procedure Language PLR

Defining Procedure Language PLR

From
"Schade, Jeffrey"
Date:
<div class="WordSection1"><p class="MsoNormal">My users have requested access to PLR for defining UDFs in Postgres on
GreenPlumDCA. When I installed R and ran the CREATE LANGUAGE the PLR language option was defined as not trusted, I
believethis is because there is no validator function.<p class="MsoNormal"> <p class="MsoNormal">Is there a default
validatorfunction available for PLR? I assume I do not want to switch this to a trusted language without a way of
validatingthe function code.<p class="MsoNormal">Any assistance would be appreciated.<p class="MsoNormal"> <p
class="MsoNormal"><i><spanstyle="font-size:13.5pt;font-family:"Arial","sans-serif";color:blue">Jeff</span></i><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:#1F497D"></span><p class="MsoNormal"><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:blue">_________________________________________<br
/></span></i><b><i><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Jeffrey Schade
</span></i></b><spanstyle="font-size:12.0pt;font-family:"Times New Roman","serif";color:#1F497D"></span><p
class="MsoNormal"><b><i><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">Systems Consultant,
TechnologyEngineering</span></i></b><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:#1F497D"></span><pclass="MsoNormal"><b><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:blue"><br/></span></b><b><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:maroon">ISO</span></i></b><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:blue"><br /></span><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:maroon">545Washington Boulevard<br />Jersey City, NJ
07310<br/>Voice: (201) 469-3738</span></i><span style="font-size:12.0pt;font-family:"Times New
Roman","serif";color:blue"></span><pclass="MsoNormal"><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:maroon"> FAX: (201) 748-1500  <br /></span></i><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:blue"><a href="mailto:jschade@iso.com"><i><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:blue">jschade@iso.com</span></i></a></span><span
style="color:#1F497D"></span><pclass="MsoNormal"> </div> 

Re: Defining Procedure Language PLR

From
Guillaume Lelarge
Date:
On Fri, 2011-12-30 at 13:18 -0500, Schade, Jeffrey wrote:
> My users have requested access to PLR for defining UDFs in Postgres on
> GreenPlum DCA. When I installed R and ran the CREATE LANGUAGE the PLR
> language option was defined as not trusted, I believe this is because
> there is no validator function.
> 
>  
> 
> Is there a default validator function available for PLR? I assume I do
> not want to switch this to a trusted language without a way of
> validating the function code.
> 

I guess you should ask this on the PL/R mailing list.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3:
http://www.postgresql-sessions.org