From: sankar <san_madhav@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: Using one connection object.
Date: Wed, 7 May 2003 14:46:10 -0700
Message-ID: <Sea2-DAV38xSQWBLYu700000dc7@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: san_madhav@hotmail.com
Subject: Re: Using one connection object.
In-Reply-To: <Sea2-DAV38xSQWBLYu700000dc7@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox