Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9A7661337C06 for ; Thu, 28 Apr 2011 11:30:19 -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 35117-01-2 for ; Thu, 28 Apr 2011 14:30:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 0CB3B1337C0C for ; Thu, 28 Apr 2011 11:29:56 -0300 (ADT) Received: by pvg12 with SMTP id 12so1832368pvg.19 for ; Thu, 28 Apr 2011 07:29:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:from:to:subject:date:user-agent:cc:references :in-reply-to:x-kmail-markup:mime-version:content-type :content-transfer-encoding:message-id; bh=qwMCw2lFa1l/CLDRIwlQHHSTQDMlXpuwoBAl4Ae2Z4Y=; b=QaK2G+t/454r7OFR61wMbvkM6GZKnskBmCd5y2pWdI0BThm27z5BYPJImpe29tPA56 yiUPGE718h6BDwGHMbbQqIUP039zWfNV/YdrcofoUnyoo3cnK5W+gZ6gq0sfVfiGYn8t 3VSpvmHzSKitGV2GAHbpW4ZHpIWB/Pib5l9sY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:cc:references:in-reply-to :x-kmail-markup:mime-version:content-type:content-transfer-encoding :message-id; b=VPfJoYDbWc9U3CneMft0jET1pN6EP6L6Y0x2Qp2G+dkYzOYu1a5Msl6xv4vZtTA8ym 1J9AuMEzfENSb8E5gXWhwaVFJGv3qQd53EW8tWJUsmgXk8CZb8pxcqBoT3kOb1grOgF9 RnsX5L2j8CbiuhpkXy65kj9wEzYDRJnb0hHNc= Received: by 10.68.62.132 with SMTP id y4mr3722035pbr.212.1304000997277; Thu, 28 Apr 2011 07:29:57 -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 f3sm1223962pbq.58.2011.04.28.07.29.54 (version=SSLv3 cipher=OTHER); Thu, 28 Apr 2011 07:29:55 -0700 (PDT) From: Adrian Klaver To: pgsql-general@postgresql.org Subject: Re: plpython module import errors Date: Thu, 28 Apr 2011 07:29:52 -0700 User-Agent: KMail/1.13.5 (Linux/2.6.32-30-generic; KDE/4.4.5; i686; ; ) Cc: c k , sim@compulab.co.il, mgainty@hotmail.com, Karsten.Hilbert@gmx.net References: <20110428133054.GI3783@hermes.hilbert.loc> In-Reply-To: X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_gnXuNFWe/Rb+7sf" Content-Transfer-Encoding: 7bit Message-Id: <201104280729.53015.adrian.klaver@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.887 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201104/988 X-Sequence-Number: 175344 --Boundary-01=_gnXuNFWe/Rb+7sf Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit On Thursday, April 28, 2011 7:11:50 am c k wrote: > Yes, there are three version (now). I am aware of only 2.7 installed > by default in /usr/lib directory and 3.2 which I have installed > externally. But the function given above shows version 2.6.4. > Now the question is how to change the version postresql is calling for > function execution? > I have also complied the postgresql source using python option, but > nothing happens. Is there is variable or like where we can set the > python deirectory and version postresql have to use? > Because as per manual, after installing 3.2, I have complied source, > but still it does not support to python 3.2! It can only compile against one and by default that will be the 'system ' version. To determine what that is , at the system command line enter: python -V If you want to compile against 3.2 you will have to tell Postgres that. See here for more detail: http://www.postgresql.org/docs/9.0/interactive/install-procedure.html PYTHON Full path to the Python interpreter. This will be used to determine the dependencies for building PL/Python. Also, whether Python 2 or 3 is specified here (or otherwise implicitly chosen) determines which variant of the PL/Python language becomes available. See Section 42.1 for more information. > Kindly give the details. > Thanks and regards, > > C P Kulkarni > -- Adrian Klaver adrian.klaver@gmail.com --Boundary-01=_gnXuNFWe/Rb+7sf Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: 7bit

On Thursday, April 28, 2011 7:11:50 am c k wrote:

> Yes, there are three version (now). I am aware of only 2.7 installed

> by default in /usr/lib directory and 3.2 which I have installed

> externally. But the function given above shows version 2.6.4.

> Now the question is how to change the version postresql is calling for

> function execution?

> I have also complied the postgresql source using python option, but

> nothing happens. Is there is variable or like where we can set the

> python deirectory and version postresql have to use?

> Because as per manual, after installing 3.2, I have complied source,

> but still it does not support to python 3.2!

It can only compile against one and by default that will be the 'system ' version. To determine what that is , at the system command line enter:

python -V

If you want to compile against 3.2 you will have to tell Postgres that. See here for more detail:

http://www.postgresql.org/docs/9.0/interactive/install-procedure.html

PYTHON

Full path to the Python interpreter. This will be used to determine the dependencies for building PL/Python. Also, whether Python 2 or 3 is specified here (or otherwise implicitly chosen) determines which variant of the PL/Python language becomes available. See Section 42.1 for more information.

> Kindly give the details.

> Thanks and regards,

>

> C P Kulkarni

>

--

Adrian Klaver

adrian.klaver@gmail.com

--Boundary-01=_gnXuNFWe/Rb+7sf--