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, 24 Aug 2011 06:41:51 -0700
User-Agent: KMail/1.13.5 (Linux/2.6.32-33-generic; KDE/4.4.5; i686; ; )
Cc: Craig Ringer <ringerc@ringerc.id.au>,
 pgsql-general@postgresql.org
References: 
 <CAN2Y=uMs3SwWwogKpazMPKFTbuJZngOhaDLxYg+XReJK=BzpPA@mail.gmail.com>
	<201108220738.50556.adrian.klaver@gmail.com>
	<CAN2Y=uM+OBMzWihhBTKmY45=JLUYZwGGoJ-CgYywjO5X86h60g@mail.gmail.com>
In-Reply-To: 
 <CAN2Y=uM+OBMzWihhBTKmY45=JLUYZwGGoJ-CgYywjO5X86h60g@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201108240641.51863.adrian.klaver@gmail.com>

On Tuesday, August 23, 2011 11:10:19 pm c k wrote:
> Yes,

> ImportError: No module named site
> ImportError: No module named site
> ImportError: No module named site
> 
> This last line is added every time I call any plpython function. Here is
> the simple plpython function.
> 
> CREATE OR REPLACE FUNCTION software.pyver()
>   RETURNS text AS
> $BODY$
> import sys
> #return sys.version
> return sys.path
> $BODY$
>   LANGUAGE plpythonu VOLATILE
>   COST 100;
> 
> What is the problem?

plpythonu cannot find the Python installation. site is a module imported by 
default by the Python interpreter. When you removed 2.7 you probably also 
removed the PATH entries for Python. So to recap, previously you where running 
plpythonu compiled with 2.6 using a PATH leading to 2.7, hence the crashes. Now 
you have 2.7 out of the way, but no PATH to 2.6.

> 
> 
> Chaitany Kulkarni
>

-- 
Adrian Klaver
adrian.klaver@gmail.com