Re: Interaction between Cursor and Transaction storage?

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема Re: Interaction between Cursor and Transaction storage?
Дата
Msg-id 3E806111.5929A731@rodos.fzk.de
обсуждение исходный текст
Ответ на Interaction between Cursor and Transaction storage?  ("William West" <wwest@csc.com>)
Список 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 по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: Asynchronous Communication across two independent
Следующее
От: Damien Dougan
Дата:
Сообщение: Re: Asynchronous Communication across two independent components