Search Postgresql Archives

Re: postgresql server crash on windows 7 when using plpython

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux