Re: Interaction between Cursor and Transaction storage? - Mailing list pgsql-interfaces

From Christoph Haller
Subject Re: Interaction between Cursor and Transaction storage?
Date
Msg-id 3E806111.5929A731@rodos.fzk.de
Whole thread Raw
In response to Interaction between Cursor and Transaction storage?  ("William West" <wwest@csc.com>)
List pgsql-interfaces
>
> QUESTION 1:
>
> Should RO-APP be doing anything other than closing
> the Cursors, to tell the Engine to just 'cleanup' when
> RO-APP is about to close its fe-be session and exit?
NO.
>
> QUESTION 2:
>
> Will an attempt by the RW-APP to do a commit or rollback
> while the RO-APP is fetching through an open Cursor cause
> RW-APP to wait until RO-APP closes the Cursor?
NO.
>
> QUESTION 3:
>
> Will an attempt by the RO-APP to open a Cursor while
> the RW-APP is performing a commit or rollback cause
> RO-APP to wait until RW-APP finishes its commit/
> rollback?
NO.
>
The answers are given to my best knowledge. If you prefer to be
absolutely sure you should post your questions to the hackers list,
as you've received no reply on this list within three days.
Regards, Christoph



pgsql-interfaces by date:

Previous
From: Christoph Haller
Date:
Subject: Re: Asynchronous Communication across two independent
Next
From: Damien Dougan
Date:
Subject: Re: Asynchronous Communication across two independent components