Re: concurrent cursors possible with portals?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: concurrent cursors possible with portals?
Дата
Msg-id 28820.1088703281@sss.pgh.pa.us
обсуждение исходный текст
Ответ на function accessing other db  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Ответы Multiple clients over singele TCP/IP connection  ("M. Bastin" <marcbastin@mindspring.com>)
Список pgsql-novice
"M. Bastin" <marcbastin@mindspring.com> writes:
> The only thing that bothers me is the Sync command that would put an
> end to all portals at once isn't it?

Not if you are inside a transaction block (ie, have issued a BEGIN
command).

A possibly more serious issue is that an error detected in any one of
the portals aborts the transaction and thus you lose all the portals.
We may eventually have a solution for that involving subtransactions.

            regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: .pgpass
Следующее
От: Tom Lane
Дата:
Сообщение: Re: .pgpass