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

Re: Autonomous subtransactions

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Gianni Ciolli <gianni(dot)ciolli(at)2ndquadrant(dot)it>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autonomous subtransactions
Date: 2011-12-19 15:52:40
Message-ID: CABRT9RDMv5aKaF=jQx+T5=EQcqQpPkwLzjo4+2nb9=ryYHes+A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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").

2. There's no reason why two autonomous transactions should have a
"main / sub" relationship. They are autonomous -- they should not
depend on the state of the "outer" transaction.

Now, the initial implementation may well have such limits, but I think
you should design your proposal to accommodate the above two features
in the future without having to redesign the syntax.

Maybe look at SAVEPOINTs for inspiration. There can be multiple
savepoints in a single transaction, and they can be released/rolled
back to, at any time.

Regards,
Marti

In response to

Responses

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-12-19 16:12:13
Subject: Re: Command Triggers
Previous:From: Pavel StehuleDate: 2011-12-19 15:47:25
Subject: Re: review: CHECK FUNCTION statement

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