Re: cursors outside transactions

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/