Re: How to 'register' functions, so they can be called (plpythonu)

blay bloo wrote:
> I am defining some functions using plpythonu, through the standard means.
>
> Here I have one function (test1) which calls another (testfunc). When
> I excute this I get the following error:
>
> ERROR:  plpython: function "test1" failed
> DETAIL:  <type 'exceptions.NameError'>: global name 'testfunc' is not defined

You need to call it as an SQL statement "SELECT testfunc(...)"

> However, from the console, select testfunc('test') works fine.

I believe the python embedder mangles the function names when it loads
them into PG, so you can't call them directly.

--
   Richard Huxton
   Archonet Ltd