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

From Tom Lane
Subject Re: concurrent cursors possible with portals?
Date
Msg-id 28820.1088703281@sss.pgh.pa.us
Whole thread Raw
In response to function accessing other db  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Responses Multiple clients over singele TCP/IP connection
List 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 by date:

Previous
From:
Date:
Subject: Re: .pgpass
Next
From: Tom Lane
Date:
Subject: Re: .pgpass