Re: Interaction between Cursor and Transaction storage?

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: wwest(at)csc(dot)com
Subject: Re: Interaction between Cursor and Transaction storage?
Date: 2003-03-25 14:00:50
Message-ID: 3E806111.5929A731@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Damien Dougan 2003-03-25 14:14:46 Re: Asynchronous Communication across two independent components
Previous Message Christoph Haller 2003-03-25 13:41:40 Re: Asynchronous Communication across two independent