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(at)mired(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073