TODO item? ---------------------------------------------------------------------------
Tom Lane wrote: > 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 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend