Обсуждение: Savepoints inside functions
If we get savepoints working inside functions, would they work if the function is not called from a multi-statement transaction? -- 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, Pennsylvania19073
Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > If we get savepoints working inside functions, would they work if the > > function is not called from a multi-statement transaction? > > We'll make sure they do ;-) That will be a neat trick because it will become a multi-statement transaction when it wasn't before. -- 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, Pennsylvania19073
Bruce Momjian <pgman@candle.pha.pa.us> writes: > If we get savepoints working inside functions, would they work if the > function is not called from a multi-statement transaction? We'll make sure they do ;-) regards, tom lane
Bruce Momjian <pgman@candle.pha.pa.us> writes: >>> If we get savepoints working inside functions, would they work if the >>> function is not called from a multi-statement transaction? >> >> We'll make sure they do ;-) > That will be a neat trick because it will become a multi-statement > transaction when it wasn't before. Not really. At most it might require relaxing a couple of asserts in the state machine in xact.c. regards, tom lane