Re: [GENERAL] postgresql server crash on windows 7 when using plpython

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(dot)klaver(at)gmail(dot)com>wrote:

>
>
> On Tue, Aug 9, 2011 at 7:54 AM, c k <shreeseva(dot)learning(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
>