Re: Autonomous subtransactions

On Mon, Dec 19, 2011 at 3:52 PM, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
> On Sun, Dec 18, 2011 at 10:28, Gianni Ciolli
> <gianni(dot)ciolli(at)2ndquadrant(dot)it> wrote:
>>  http://wiki.postgresql.org/wiki/Autonomous_subtransactions
>>
>> It is meant to be an ongoing project, requesting comments and
>> contributions, rather than a conclusive document.
>
> In addition to what Jim Nasby said, this proposal seems a bit
> inflexible. In particular:
> 1. It limits us to exactly 2 autonomous transactions at any time (the
> main one and the "subtransaction").

It's not clear to me why you think there would be a limitation to
exactly 2 autonomous transactions.

The intention would be to have a theoretically unlimited number,
subject to resource limits, just as normal subtransactions already do.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services