Rod Taylor <[EMAIL PROTECTED]> writes: > On Fri, 2003-08-08 at 16:00, Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >>> Seems we have a problem with pooled connections and WITH HOLD cursors. >>> We have code to reset transaction state and variables via RESET ALL, but >>> how do we remove WITH HOLD cursors when we pass a connection to a new >>> client? >> >> 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".
> Actually, prepared statements in a pooled environment would be very > useful if you could ask what the currently prepared names for that > connection are. Hm. Good thought. Maybe the same is true of held cursors. It would be a simple addition at either the protocol or SQL level to list the names of existing prepared statements and portals. Probably too late for 7.4 though. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match