create or replace function software.python_test() returns text as
$body$
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
$body$
language plpythonu volatile security definer;
When running the same code from python prompt, it run correctly without any error.
Chaitanya Kulkarni
On Wed, Aug 10, 2011 at 12:57 AM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
On Tue, Aug 9, 2011 at 7:54 AM, c k <shreeseva.learning@xxxxxxxxx> wrote:
Dear Friends,
For client requirements, I am testing postgresql 9.0.4 on windows 7 with plpython. First I installed python 2.7 and then added python installation path to windows PATH variable. Then installed postgresql from one-click installer. Server started and every thing was ok. Then I go to create plpythonu in a database. But it failed. After searching, I found that it needs python 2.6. So I again installed python 2.6 and then dropped plpython from database and created again. It was successful. Normal python functions returning text etc. are working but when conatining
import sys
from uuid import getnode as get_mac
mac = get_mac()
return mac
fails. What will be the reason?
What would be the error message(s)?
The actual function code would also be helpful, to put things into context.
Advance thanks for your help.
Chaitanya Kulkarni
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
