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