Re: using the same connection?

Well actually this particular connection is just for selects...

On Tue, 06 Feb 2001, you wrote:
> 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
--
Mathieu Dube
Mondo-Live
www.flipr.com