Here is the actual function. 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.kla...@gmail.com>wrote: > > > On Tue, Aug 9, 2011 at 7:54 AM, c k <shreeseva.learn...@gmail.com> 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.kla...@gmail.com >
