Re: WITH HOLD and pooled connections

On Fri, Aug 08, 2003 at 04:00:22PM -0400, 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".

Well, unless you're prepared to manually manage these resources
yourself (i.e. DEALLOCATE a prepared query when you're finished
with it, CLOSE a holdable cursor).

-Neil