Обсуждение: 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