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@zembu.com
-- 
Mathieu Dube    
Mondo-Live            
www.flipr.com