Re: plpython

KM,

>
> Can someone hint on resources for using plpython for writing stored
> procedures ?
> I have gone thru official docs for 8.1.5 for plpythonu but its not in
> detail/with examples.

CREATE OR REPLACE FUNCTION myfunc(text)
RETURNS text AS
$BODY$
eingabe=args[0]
hello = "Good Morning %s" % (eingabe,)

return hello
$BODY$
LANGUAGE 'plpythonu' VOLATILE;
ALTER FUNCTION myfunc(text) OWNER TO postgres;

that as a first example to get you started. The other one I could give you
is using Pyro, which brings in rather uncommon challenges.

>When is plpython going to be considered safe ? any targeted version ?

Hey, you fell into the same "safe" and "unsafe" trap than me!

"unsafe" does not have the information: "it is possibly errorprone to use
this language"

"unsafe" simply says: "it is impossible for the database to guarantee, that
a bad minded programmer can do harmfull thins with this language"

For example: with plpython you can read and delete files on the server.
There is no way for PostgreSQL to stop plpython from doing harm; so it is
considered "unsafe".

(Btw: there is no restricted mode of execution for Python, google the Python
Mailingslists for it; "sandbox" is a helpfull keyword)

So: plpython is only recommended to be used by trustworthy programmers. Not
by the general public.

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Python: the only language with more web frameworks than keywords.