Обсуждение: How to 'register' functions, so they can be called (plpythonu)

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

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

I was wondering how do I 'register'/'reference' these functions so
that one function can call another? I am guessing this is important,
i.e. how will I access the complete functionality of the general
python libs?

Cheers, Blay.

PS functions are defined in the usual way - e.g.

create or replace function test1(text) returns integer as $$
return 1
$$ language 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
>
> However, from the console, select testfunc('test') works fine.
>
> I was wondering how do I 'register'/'reference' these functions so
> that one function can call another?

You can't, because the name you give to the function lives in Postgres'
namespace, not Python's.  Therefore you can only call the other function
using the SPI interface that PL/Python offers you.

> I am guessing this is important,
> i.e. how will I access the complete functionality of the general
> python libs?

This is quite different -- I'm guessing the Python library can be
accessed via normal means.  What you cannot do is use Postgres' CREATE
FUNCTION to define a regular Python function (i.e. you cannot extend the
"library").

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
Bob [Floyd] used to say that he was planning to get a Ph.D. by the "green
stamp method," namely by saving envelopes addressed to him as 'Dr. Floyd'.
After collecting 500 such letters, he mused, a university somewhere in
Arizona would probably grant him a degree.              (Don Knuth)

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

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


do you think it possible to use the internal system catalogs to lookup
the 'mangled' names?