Re: [BUGS] plpgsql does not close cursors when a block ends

#1

Marcel Gsteiger wrote:

Quote:

I created a plpgsql function declaring and then using a cursor.
After opening and using this cursor, I forgot to close it. Now
when the function terminates, this cursor remains open. Then,
when I call the function again with other parameters, the OPEN
CURSOR complains about the cursor declared within the function
already being open.

The system is working as designed.

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (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 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] plpgsql does not close cursors when a block ends

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] plpgsql does not close cursors when a block ends - 11-13-2003 , 10:15 AM