Re: PlPython - Mailing list pgsql-hackers

From Kevin Jacobs
Subject Re: PlPython
Date
Msg-id Pine.LNX.4.44.0306230645070.22187-100000@penguin.theopalgroup.com
Whole thread Raw
In response to Re: PlPython  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sun, 22 Jun 2003, Tom Lane wrote:
> Kevin Jacobs <jacobs@penguin.theopalgroup.com> writes:
> > Attached is a patch that removes all of the RExec code from plpython from
> > the current PostgreSQL CVS.  In addition, plpython needs to be changed to an
> > untrusted language in createlang.
> 
> I am inclined to rename plpython to plpythonu, by analogy to pltclu.

In 7.4, I would do this.  In the next 7.3.x release, I would leave the name
as is, but still make plpython untrusted.  It will cause some problems, but
safety and integrity are more important here.  After all, the alternative is
to drop the PL entirely.

> On the other hand, this would create headaches for people who are trying
> to load dump files that declare plpython or contain plpython-language
> functions.  I can't think of any non-kluge solution to this (kluge
> solutions would include putting special-case code into CREATE FUNCTION
> to change 'plpython' to 'plpythonu' ...)

Allowing both plpython and plpythonu to be added as separate languages
should be sufficient.  This way, we effectively deprecate plpython, or at
least defer its final removal until the restricted execution problem can be
solved.  I hope to start looking into exactly what needs to be done to
restore that functionality in the next few weeks.

Thanks,
-Kevin

-- 
--
Kevin Jacobs
The OPAL Group - Enterprise Systems Architect
Voice: (216) 986-0710 x 19         E-mail: jacobs@theopalgroup.com
Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com



pgsql-hackers by date:

Previous
From: "Sander Steffann"
Date:
Subject: Re: PlPython
Next
From: Aizaz Ahmed
Date:
Subject: Re: pg_guc