From owner-freebsd-python@FreeBSD.ORG Thu Sep 29 15:55:31 2005
Return-Path: <owner-freebsd-python@FreeBSD.ORG>
X-Original-To: freebsd-python@freebsd.org
Delivered-To: freebsd-python@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
by hub.freebsd.org (Postfix) with ESMTP id 9A58216A41F;
Thu, 29 Sep 2005 15:55:31 +0000 (GMT)
(envelope-from rcoleman@criticalmagic.com)
Received: from saturn.criticalmagic.com (saturn.criticalmagic.com
[69.61.68.51]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4EE1A43D48;
Thu, 29 Sep 2005 15:55:31 +0000 (GMT)
(envelope-from rcoleman@criticalmagic.com)
Received: from [10.40.30.82] (delta.ciphertrust.com [216.235.158.34])
by saturn.criticalmagic.com (Postfix) with ESMTP id 7C47C3BD57;
Thu, 29 Sep 2005 11:55:30 -0400 (EDT)
Message-ID: <433C0E7E.50409@criticalmagic.com>
Date: Thu, 29 Sep 2005 11:55:42 -0400
From: Richard Coleman <rcoleman@criticalmagic.com>
Organization: Critical Magic
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050807)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: freebsd-ports@freebsd.org, freebsd-python@freebsd.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc:
Subject: problem with PL/python on postgresql-8.0
X-BeenThere: freebsd-python@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: FreeBSD-specific Python issues <freebsd-python.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>,
<mailto:freebsd-python-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-python>
List-Post: <mailto:freebsd-python@freebsd.org>
List-Help: <mailto:freebsd-python-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>,
<mailto:freebsd-python-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 29 Sep 2005 15:55:31 -0000
I am trying to get PL/python working on postgresql-8.0. I'm using the default build for all the
ports, with the exception that I've turned on threads in Python. When I try to add plpythonu to a
database using createlang, I get the following error:
createlang: language installation failed: ERROR: could not load library
"/usr/local/lib/postgresql/plpython.so": dlopen '/usr/local/lib/postgresql/plpython.so' failed.
(/usr/local/lib/python2.4/config/libpython2.4.so: Undefined symbol "pthread_attr_destroy")
Here is my current setup:
1. postgresql-plpython-8.0.3
2. postgresql-server-8.0.3
3. python-2.4.1_3
4. FreeBSD 5-stable (src tree from about a month ago)
5. ports tree was from about a week ago
Anyone have suggestions?
Richard Coleman
rcoleman@criticalmagic.com
From owner-freebsd-python@FreeBSD.ORG Thu Sep 29 16:12:29 2005
Return-Path: <owner-freebsd-python@FreeBSD.ORG>
X-Original-To: freebsd-python@freebsd.org
Delivered-To: freebsd-python@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
by hub.freebsd.org (Postfix) with ESMTP id 2674A16A41F;
Thu, 29 Sep 2005 16:12:29 +0000 (GMT)
(envelope-from neuhauser@sigpipe.cz)
Received: from isis.sigpipe.cz (fw.sigpipe.cz [62.245.70.224])
by mx1.FreeBSD.org (Postfix) with ESMTP id B652343D49;
Thu, 29 Sep 2005 16:12:24 +0000 (GMT)
(envelope-from neuhauser@sigpipe.cz)
Received: by isis.sigpipe.cz (Postfix, from userid 1001)
id 7BA5C1F87BED; Thu, 29 Sep 2005 18:12:23 +0200 (CEST)
Date: Thu, 29 Sep 2005 18:12:23 +0200
From: Roman Neuhauser <neuhauser@sigpipe.cz>
To: Richard Coleman <rcoleman@criticalmagic.com>
Message-ID: <20050929161223.GA4979@isis.sigpipe.cz>
Mail-Followup-To: Richard Coleman <rcoleman@criticalmagic.com>,
freebsd-ports@freebsd.org, freebsd-python@freebsd.org
References: <433C0E7E.50409@criticalmagic.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <433C0E7E.50409@criticalmagic.com>
User-Agent: Mutt/1.5.9i
Cc: freebsd-ports@freebsd.org, freebsd-python@freebsd.org
Subject: Re: problem with PL/python on postgresql-8.0
X-BeenThere: freebsd-python@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: FreeBSD-specific Python issues <freebsd-python.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>,
<mailto:freebsd-python-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-python>
List-Post: <mailto:freebsd-python@freebsd.org>
List-Help: <mailto:freebsd-python-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-python>,
<mailto:freebsd-python-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 29 Sep 2005 16:12:29 -0000
# rcoleman@criticalmagic.com / 2005-09-29 11:55:42 -0400:
> I am trying to get PL/python working on postgresql-8.0. I'm using the
> default build for all the ports, with the exception that I've turned on
> threads in Python. When I try to add plpythonu to a database using
> createlang, I get the following error:
>
> createlang: language installation failed: ERROR: could not load library
> "/usr/local/lib/postgresql/plpython.so": dlopen
> '/usr/local/lib/postgresql/plpython.so' failed.
> (/usr/local/lib/python2.4/config/libpython2.4.so: Undefined symbol
> "pthread_attr_destroy")
That's in the PostgreSQL FAQ I think... Ummm, no, but check this out:
http://search.postgresql.org/archives.search?cs=utf-8&fm=on&st=20&dt=back&q=freebsd+python+threads&ul=http%3A%2F%2Farchives.postgresql.org%2Fpgsql-hackers%2F%25&dp=0&o=0&ps=10&s=date
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991