Thread: Using one connection object.

Using one connection object.

From
"sankar"
Date:
Hi,
I am using postgresql 7.2 on red hat linux.I am having only one connection to the database thro
PGconn(struct pg_conn ) which serves all the clients. I understand that PGconn is not thread safe.
So from my program I am having mutexes to protect PGconn from multiple access by 2 or more threads.
 
Using this model execution goes thro for around 20/30 queries. After that somehow ExecTuplesOK() call from one thread is blocking for some reason because of which other threads are not able to proceed. (Pls note I have protected call to ExecTuplesOK()  using mutex so that only one  thread can enter it.)
 
If anybody has any idea pls let me know..
 
Thanks in advance
Sankarshana M