My question again is:
How can the upper transaction be aware of an aborted lower transaction?
JLL
Tom Lane wrote:
>
> Bruce Momjian <pgman@candle.pha.pa.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