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.