Re: concurrent cursors possible with portals? - Mailing list pgsql-novice

From Tom Lane
Subject Re: concurrent cursors possible with portals?
Date
Msg-id 28494.1088701590@sss.pgh.pa.us
Whole thread Raw
In response to concurrent cursors possible with portals?  ("M. Bastin" <marcbastin@mindspring.com>)
List 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 by date:

Previous
From: "M. Bastin"
Date:
Subject: Re: concurrent cursors possible with portals?
Next
From: "M. Bastin"
Date:
Subject: fronted-backend protocol request, + "select for edit" request