From owner-freebsd-ports@FreeBSD.ORG  Thu Sep 29 15:55:31 2005
Return-Path: <owner-freebsd-ports@FreeBSD.ORG>
X-Original-To: freebsd-ports@freebsd.org
Delivered-To: freebsd-ports@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-ports@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Porting software to FreeBSD <freebsd-ports.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports>
List-Post: <mailto:freebsd-ports@freebsd.org>
List-Help: <mailto:freebsd-ports-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ports>,
	<mailto:freebsd-ports-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