Re: behavior at the end of a transaction

On Mon, 19 Sep 2011 15:34:19 -0500, Kevin Grittner wrote:
> Jean-Max Reymond <jmreymond@gmail.com> wrote:
>
>> On commit or rollback statement, I expect that all the cursors
>> are closed (all my Resultset not closed) in the postgres database.
>> is it correct ?
>
> No.
>
> http://www.postgresql.org/docs/9.1/interactive/sql-declare.html
>
> In particular, see the WITH/WITHOUT HOLD section.
>
> -Kevin

Don't worry, If you "forget" result sets, when those will be GCed then
cursors will be closed soon, too.

Regards,
Radosław Smogura