On Tue, Feb 06, 2001 at 11:08:49AM -0500, Mathieu Dube wrote:
> Hi y'all,
> Is it a bad idea for an app to keep just a couple of connections to a
> database, put semaphore/mutex on them and reuse them all through the program?
> Of course I would check if their PQstatus isnt at CONNECTION_BAD and
> reconnect if they were...
You would have to hold the lock from BEGIN until COMMIT.
Otherwise, connection re-use is normal.
Nathan Myers
ncm(at)zembu(dot)com