From owner-freebsd-python@FreeBSD.ORG Thu Sep 29 15:55:31 2005 Return-Path: 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 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: 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 To: Richard Coleman Message-ID: <20050929161223.GA4979@isis.sigpipe.cz> Mail-Followup-To: Richard Coleman , 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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