On Mon, Dec 19, 2011 at 20:34, Simon Riggs <si...@2ndquadrant.com> wrote: > It's not clear to me why you think there would be a limitation to > exactly 2 autonomous transactions.
Sorry my bad, I didn't read the proposal carefully. Nesting does indeed allow multiple autonomous subtransactions. Maybe that's just my paranoia, but the fact that subtransactions aren't named means it's pretty easy to accidentally get "out of step" and commit the wrong subtransaction. I see app developers often messing up BEGIN/COMMIT/ROLLBACK already. This is why I like the SAVEPOINT style; it's obvious when there's a bug. (I do realize that allowing subtransactions to commit out of order also makes it failure prone) Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers