Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 1E925B5DC41
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Wed, 10 Aug 2011 11:05:09 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 01735-03
	for <pgsql-general-postgresql.org@mail.postgresql.org>;
	Wed, 10 Aug 2011 14:05:01 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iy0-f172.google.com (mail-iy0-f172.google.com
	[209.85.210.172])
	by mail.postgresql.org (Postfix) with ESMTP id 785ACB5DD08
	for <pgsql-general@postgresql.org>;
	Wed, 10 Aug 2011 11:04:48 -0300 (ADT)
Received: by iye7 with SMTP id 7so1266275iye.17
	for <pgsql-general@postgresql.org>;
	Wed, 10 Aug 2011 07:04:48 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=from:to:subject:date:user-agent:cc:references:in-reply-to
	:mime-version:content-type:content-transfer-encoding:message-id;
	bh=HyeVdmm/hLEyBY0TXt4ytBFYTjSKGEtB3LdAC9Lnvb0=;
	b=uLQHA23apmBjULH6qJRhoZKs70DgKUxw+Xok8h077KqG+caMu8980rit73gIIPjqxG
	ctzP5FpYdEtjR9Xr4+3T2h3O2HHz17o554fGjtB+DLp+A5u6x55DlEvSVCe2PcQ/M1gn
	yd9YYsH/KKT9mPMVTToJQGJNbRRFtOYrzQYYg=
Received: by 10.231.35.73 with SMTP id o9mr10068212ibd.46.1312985088276;
	Wed, 10 Aug 2011 07:04:48 -0700 (PDT)
Received: from tucker.localnet (c-24-17-164-54.hsd1.wa.comcast.net
	[24.17.164.54])
	by mx.google.com with ESMTPS id v3sm746062ibh.67.2011.08.10.07.04.46
	(version=SSLv3 cipher=OTHER); Wed, 10 Aug 2011 07:04:47 -0700 (PDT)
From: Adrian Klaver <adrian.klaver@gmail.com>
To: c k <shreeseva.learning@gmail.com>
Subject: Re: postgresql server crash on windows 7 when using plpython
Date: Wed, 10 Aug 2011 07:04:44 -0700
User-Agent: KMail/1.13.5 (Linux/2.6.32-33-generic; KDE/4.4.5; i686; ; )
Cc: pgsql-general@postgresql.org
References: 
 <CAN2Y=uMs3SwWwogKpazMPKFTbuJZngOhaDLxYg+XReJK=BzpPA@mail.gmail.com>
	<CANf5jyPA2Sq1vaHGk0VCT6yPGyiiHspuxFyK3eWYV+xsGR04TA@mail.gmail.com>
	<CAN2Y=uNbpzZ=z_KHBOwf_4qcOuZNp+PrPYMaF7qvQ_Wi7YOJLA@mail.gmail.com>
In-Reply-To: 
 <CAN2Y=uNbpzZ=z_KHBOwf_4qcOuZNp+PrPYMaF7qvQ_Wi7YOJLA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201108100704.44907.adrian.klaver@gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201108/292
X-Sequence-Number: 178574

On Tuesday, August 09, 2011 10:13:17 pm c k wrote:
> 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.

The above function runs correctly in Postgres 9.0.3 on my Linux machine. I would 
say Craigs  post about multiple versions of uuid causing the problem is the 
answer to your problem.


> 
> 
> Chaitanya Kulkarni
> 


-- 
Adrian Klaver
adrian.klaver@gmail.com