Re: cursors outside transactions - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: cursors outside transactions
Date
Msg-id 3E769987.DA48CF5F@tpf.co.jp
Whole thread Raw
In response to cursors outside transactions  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> 
> On Mon, Mar 17, 2003 at 09:48:34PM -0500, Neil Conway wrote:
> 
> > (2) Use MVCC to ensure that the snapshot of the database that the
> > transaction had is still valid, even after the transaction itself has
> > committed.
> 
> What about opening a pseudo-transaction that exists only to serve the
> cursor?  That frees you from modifying VACUUM and resource management.

The simplest way to achieve it is to invoke another
session internally. Even some clients use the trick.
However, I'm little excited about it.

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/


pgsql-hackers by date:

Previous
From: R Blake
Date:
Subject: anyone? CREATELANG in pgsql 7.3.2 failing
Next
From: Alvaro Herrera
Date:
Subject: Nested transactions