Re: BUG #2069: Cursors are not close outside of a function - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2069: Cursors are not close outside of a function
Date
Msg-id 22441.1132932943@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2069: Cursors are not close outside of a function  ("Hubert FONGARNAND" <h.fongarnand@fiducial.fr>)
List pgsql-bugs
"Hubert FONGARNAND" <h.fongarnand@fiducial.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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2070: Encoding dependent error in comparison operators
Next
From: Jaime Casanova
Date:
Subject: Re: BUG #2069: Cursors are not close outside of a function