Savepoints inside functions

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

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, Pennsylvania 19073

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