Re: BUG #2069: Cursors are not close outside of a function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hubert FONGARNAND" <h(dot)fongarnand(at)fiducial(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2069: Cursors are not close outside of a function
Date: 2005-11-25 15:35:43
Message-ID: 22441.1132932943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Hubert FONGARNAND" <h(dot)fongarnand(at)fiducial(dot)fr> writes:
> Note that i don't close c1 after returning...
> (c1 should be close automatically because it is declared inside my
> function);

What makes you think that?

If we forcibly closed cursors at function exit, it'd be impossible to
return a cursor reference, which is a very handy feature.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2005-11-25 15:58:55 Re: BUG #2069: Cursors are not close outside of a function
Previous Message Tom Lane 2005-11-25 15:34:24 Re: BUG #2070: Encoding dependent error in comparison operators