Re: Two features left
От | Bruce Momjian |
---|---|
Тема | Re: Two features left |
Дата | |
Msg-id | 200211272055.gARKt8V29137@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Two features left (Jean-Luc Lachance <jllachan@nsd.ca>) |
Список | pgsql-general |
The upper transaction really doesn't know of the lower sub-transaction's abort, unless it looks at the result returned by the subtransaction commit, just as current code checks the commit of a non-subtransaction. Is that OK? --------------------------------------------------------------------------- Jean-Luc Lachance wrote: > 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 > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: