Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group