Thread: plpgsql does not close cursors when a block ends

Hi,

Please find enclosed my description of what I think is probably a bug
in plpgsql.

Keep up the good work, this is a wonderful product.

Best regards
Marcel Gsteiger
Milprog AG
3001 Berne
Switzerland

Freundliche Grüsse
Milprog AG
Marcel Gsteiger

Marcel Gsteiger wrote:
> 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@candle.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