Le 20/09/2011 11:36, Radosław Smogura a écrit :
> On Mon, 19 Sep 2011 15:34:19 -0500, Kevin Grittner wrote:
>> Jean-Max Reymond <jmreymond(at)gmail(dot)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.
no sure that GC will free the ressources in the postgres database