Skip site navigation (1) Skip section navigation (2)

Re: concurrent cursors possible with portals?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: concurrent cursors possible with portals?
Date: 2004-07-01 17:06:30
Message-ID: 28494.1088701590@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"M. Bastin" <marcbastin(at)mindspring(dot)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

In response to

Responses

pgsql-novice by date

Next:From: M. BastinDate: 2004-07-01 17:24:36
Subject: Re: concurrent cursors possible with portals?
Previous:From: Tom LaneDate: 2004-07-01 15:27:12
Subject: Re: .pgpass

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group