plpgsql does not close cursors when a block ends

Started by Marcel Gsteigerover 22 years ago2 messagesbugs

Jump to latest

Marcel Gsteiger

Marcel.Gsteiger@milprog.ch

over 22 years ago

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

Bruce Momjian

bruce@momjian.us

over 22 years ago

In reply to: Marcel Gsteiger (#1)

Re: plpgsql does not close cursors when a block ends

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

plpgsql does not close cursors when a block ends

Attachments: