On Fri, Feb 11, 2005 at 10:05:36PM -0500, Tom Lane wrote: > "Brian B." <[EMAIL PROTECTED]> writes: > > When setting the "LIBC_R" option, the FreeBSD port essentially sets CFLAGS > > to > > -D_THREAD_SAFE and LDFLAGS to -pthread. This is probably due to the Python > > procedural handler not being able to link with PostgreSQL until PostgreSQL > > is built pthread-aware. > > Hmm, is that a FreeBSD-specific restriction? I've not had any such > trouble on Linux or Mac OS X.
I was citing that behavior from memory. It actually builds/installs OK until one decides to add the handler to a database: $ createlang plpythonu 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") If I build the backend with the pthread stuff, this step succeeds. Thanks, Brian B. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
