From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200303220158.h2M1wAc01901@candle.pha.pa.us>
Subject: Re: plpython problem.
In-Reply-To: <15995.49662.474372.676331@guru.mired.org>
To: Mike Meyer <mwm@mired.org>
Date: Fri, 21 Mar 2003 20:58:10 -0500 (EST)
Cc: PostgreSQL-interfaces <pgsql-interfaces@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII


Can someone comment on this?

---------------------------------------------------------------------------

Mike Meyer wrote:
> Hello,
> 
> I'm sorry to bother you two directly, but my mail to pgsql-hackers
> never got answered; possibly it's caught in a spam trap somewhere.
> 
> As a python programmer who uses PostGreSQL (for which thanks), I'd
> like to use plpython for my triggers. The problem is that it requires
> a shared library of the unthreaded version of Python. Since I use the
> threading version in applications where I embed python, this creates
> the risk that the next time I build those modules, I'll be breaking my
> existing code base.
> 
> The reason the a library of the threaded build doesn't work is that
> it's looking for the posix thread routines that are in libc_r on
> FreeBSD.
> 
> Working solutions seems to be building a version of postmaster with
> thread support, or getting the plpython.so file to link in a static
> library.
> 
> I've done the latter, but the resulting plpython.so doesn't work.
> 
> Any comments on whether or what might go wrong with the former - I
> can't see any obvious problems - or how to get the latter working, or
> even an alternative solution, would be greatly appreciated.
> 
> 	Thanks,
> 	<mike
> -- 
> Mike Meyer <mwm@mired.org>		http://www.mired.org/consulting.html
> Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073