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:34:41
Message-ID: 28820.1088703281@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"M. Bastin" <marcbastin(at)mindspring(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2004-07-01 17:38:06
Subject: Re: .pgpass
Previous:From: ghaverlaDate: 2004-07-01 17:26:45
Subject: Re: .pgpass

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