Re: Nested Transactions, Abort All

Bruce Momjian wrote:

>
>The syntax was for support of script languages that don't have
>conditional constructs, like psql scripts, where you want the subxact to
>commit but if it fails, you don't want that to affect the outer
>transaction.  Are you saying there are very few cases where you don't
>care if the subxact commits or aborts?
>
>  
>
Trying to enable nested transaction on something that has no 
conditionals seems strange to me. If you're writing an app so 
complicated you so you need NTs, you'd probably not code is as psql script.

BTW, do we have real world examples of apps that are waiting to be 
ported to pgsql, needing nested transactions? Looking at the coding 
constructions used in those apps could help deciding what semantics 
would help them.

Compiere comes to my mind, being oracle now, so they'd probably prefer 
named savepoints.

Regards,
Andreas