ECPG thread-safety

Philip Yarra writes:> I've had a few tries at testing the ECPG threadsafe patch, but so> far no luck, probably due to my own lack of experience. Can someone> help me out with how to test this?> > So far I have:> - run configure> - applied Lee's patch to the source tree for 7.3.2> - edited src/Makefile.global, adding -pthread to CFLAGS and and> -lpthread to LIBS> - make and make install> - make our own pthread'd app, linking against newly installed pgsql> Then when I run our app with 3 DB threads, I can watch 2 of the threads fai=> l=20> to return from EXEC SQL, which is exactly the same behaviour we used to get.> > Can anyone point me in the right direction? I'm building on RedHat Linux 7.=> 3=20> on Intel, using all standard tools for that version (except updated bison=> =20> from 1.35 to 1.875). So gcc 2.96, gmake 3.79.1, etc. Let me know if more=20> details are required.

Even with this patch you'll still be limited by the underlying
libpq. So for example you cannot share a connection between threads
without implementing locking to prevent multiple access to that
connection.

I guess the best way would be to open a named connection for EACH
thread. This SHOULD work, but again not tested...

L.