Postgres Pro
Downloads
Home   >   mailing lists

Re: behavior at the end of a transaction - Mailing list pgsql-jdbc

From Kevin Grittner
Subject Re: behavior at the end of a transaction
Date
Msg-id 4E7760FB02000025000413A1@gw.wicourts.gov
Whole thread Raw
In response to behavior at the end of a transaction  (Jean-Max Reymond <jmreymond@gmail.com>)
Responses Re: behavior at the end of a transaction
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: Jean-Max Reymond
Date:
Subject: behavior at the end of a transaction
Next
From: Tom Lane
Date:
Subject: Re: binary patch problems