Re: Nested Transactions, Abort All

Zeugswetter Andreas SB SD wrote:

>>I'd opt for BEGIN as a start of a subtransaction (no need for special 
>>semantics in plpgsql), the corresponding END simply changes the 
>>transaction context to the parent level.
>>    
>>
>
>But 'BEGIN' in plpgsql does not start a [sub]transaction, it starts a 
>statement block. Are we intending to change that ? I think not.
>
>  
>
There are two possibilities:
Either BEGIN *does* start a subtransaction, or BEGIN does not. I don't 
see how two nesting level hierarchies in a function should be 
handleable, i.e. having independent levels of statements blocks and 
subtransactions.

BEGIN [whatever] suggests that there's also a statement closing that 
block of [whatever], but it's very legal for subtransactions to have no 
explicit end; the top level COMMIT does it all.

The SAVEPOINT semantic seems much more appropriate to describe statement 
block independent transactions in this case, so if both is implemented 
for SQL, savepoint only seems enough for plpgsql.

Regards,
Andreas