My question again is:
How can the upper transaction be aware of an aborted lower transaction?
JLL
Tom Lane wrote:
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Right. I hadn't planned on ABORT ALL, but it could be done to abort the
> > entire transaction. Is there any standard on that?
>
> I would be inclined to argue against any such thing; if I'm trying to
> confine the effects of an error by doing a subtransaction BEGIN, I don't
> think I *want* to allow something inside the subtransaction to abort my
> outer transaction ...
>
> regards, tom lane