Re: concurrent cursors possible with portals?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: concurrent cursors possible with portals?
Дата
Msg-id 28494.1088701590@sss.pgh.pa.us
обсуждение исходный текст
Ответ на concurrent cursors possible with portals?  ("M. Bastin" <marcbastin@mindspring.com>)
Список pgsql-novice
"M. Bastin" <marcbastin@mindspring.com> writes:
> I'm reading the docs about the extended query language and the
> portals.  Is it possible to use portals as a kind of concurrent
> cursors over a single TCP/IP connection?
> Or should you execute and close portals one after another and never
> execute the next portal before the previous one is closed?  (Like
> regular transactions.)

You can certainly have multiple portals open and fetch from different
ones in turn; not clear if that's what you meant.  A portal is more like
a SQL cursor than like a transaction.

            regards, tom lane

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

Предыдущее
От: "M. Bastin"
Дата:
Сообщение: Re: concurrent cursors possible with portals?
Следующее
От: "M. Bastin"
Дата:
Сообщение: fronted-backend protocol request, + "select for edit" request