Re: Nested Transactions, Abort All
Merlin Moncure <merlin.moncure@rcsonline.com>
From: "Merlin Moncure" <merlin.moncure@rcsonline.com>
To: "Alvaro Herrera" <alvherre@dcc.uchile.cl>
Cc: "PostgreSQL Hackers" <pgsql-hackers@postgresql.org>
Date: 2004-07-02T17:14:25Z
Lists: 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