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

Tue, 27 Jul 2004 09:11:55 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
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

Tue, 27 Jul 2004 10:48:36 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Savepoints inside functions 
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

Tue, 27 Jul 2004 11:00:02 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: 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 ;-)

> 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

Tue, 27 Jul 2004 11:19:24 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Savepoints inside functions 