Re: behavior at the end of a transaction

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jean-Max Reymond" <jmreymond(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: behavior at the end of a transaction
Date: 2011-09-19 20:34:19
Message-ID: 4E7760FB02000025000413A1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Tom Lane 2011-09-20 00:39:31 Re: binary patch problems
Previous Message Jean-Max Reymond 2011-09-19 20:03:26 behavior at the end of a transaction