Re: WITH HOLD and pooled connections - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WITH HOLD and pooled connections
Date
Msg-id 878.1060378438@sss.pgh.pa.us
Whole thread Raw
In response to Re: WITH HOLD and pooled connections  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: WITH HOLD and pooled connections
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Prepared statements would be just as much of a problem.  I think the
>> correct answer is simply "don't use those features in a pooled
>> environment".

> Ouch. Double ouch in fact. I'm using prepared statements extensively in 
> my current (pooled conn) app. All pure selects.
> Can this be narrowed down a bit? Is it a problem on all query types?

The point is just that there's no infrastructure to manage prepared
statements, eg for a thread to discover whether someone has already
prepped a particular statement on the current connection.  Evidently
you have set things up so that you don't need to do that.  Panic not.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgindent run
Next
From: Sean Chittenden
Date:
Subject: Re: Correlation in cost_index()