Re: Nested Transactions, Abort All - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Nested Transactions, Abort All
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB34101AEB5@Herge.rcsinc.local
Whole thread Raw
In response to Nested Transactions, Abort All  (Thomas Swan <tswan@idigx.com>)
Responses Re: Nested Transactions, Abort All
List pgsql-hackers
> If we change the syntax, say by using SUBCOMMIT/SUBABORT for
> subtransactions, then using a simple ABORT would abort the whole
> transaction tree.

Question: with the new syntax, would issuing a BEGIN inside a already
started transaction result in an error?

My concern is about say, a pl/pgsql function that opened and closed a
transation.  This could result in different behaviors depending if
called from within a transaction, which is not true of the old syntax.

Then again, since a statement is always transactionally wrapped, would
it be required to always issue SUBBEGIN if issued from within a
function?  This would address my concern.

Merlin


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Subtle bug in clog.c
Next
From: "Merlin Moncure"
Date:
Subject: anonymous cvs failure