pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Korry <korry@starband.net>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: KeithW@narrowpathinc.com, PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: plperl user function
Date: Thu, 21 Apr 2005 17:07:26 +0000
Message-ID: <1114103246.7513.19.camel@sakai> (raw)
In-Reply-To: <42680F29.4030907@commandprompt.com>
References: <20050421194438.M68704@narrowpathinc.com>
	<42680480.7080805@commandprompt.com>
	<20050421200109.M30783@narrowpathinc.com>
	<42680F29.4030907@commandprompt.com>

> > Another question:  Is there an issue with using the untrusted perl language? 
> 
> IIRC you have to be a postgresql superuser (postgres) to execute an 
> untrusted language function.


I think you meant "you have to be a postgresql superuser to create an
untrusted language function".  IIRC, a normal user can execute a
function written in an untrusted language (assuming that s/he holds the
proper EXECUTE privileges), but only a cluster superuser can create a
function written in an untrusted language.  Otherwise, it would be
difficult to create a trigger in an untrusted language. 

        -- Korry

view thread (10+ messages)  latest in thread

Message-ID: <1114103246.7513.19.camel@sakai>
Permalink:  ../1114103246.7513.19.camel@sakai/
Also on:    postgresql.org/message-id/1114103246.7513.19.camel@sakai

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: korry@starband.net, jd@commandprompt.com
  Subject: Re: plperl user function
  In-Reply-To: <1114103246.7513.19.camel@sakai>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox