Re: plpython problem.

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,
Pennsylvania19073