Lists: | pgsql-hackers |
---|
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Savepoints inside functions |
Date: | 2004-07-27 13:11:55 |
Message-ID: | 200407271311.i6RDBts23226@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Savepoints inside functions |
Date: | 2004-07-27 14:48:36 |
Message-ID: | 28494.1090939716@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Savepoints inside functions |
Date: | 2004-07-27 15:00:02 |
Message-ID: | 200407271500.i6RF02u10193@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Savepoints inside functions |
Date: | 2004-07-27 15:19:24 |
Message-ID: | 28762.1090941564@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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