Re: Nested transactions - Mailing list pgsql-patches

From Tom Lane
Subject Re: Nested transactions
Date
Msg-id 21670.1087576372@sss.pgh.pa.us
Whole thread Raw
In response to Re: Nested transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Did I make a mistake by promoting subtransactions rather than
> savepoints?

No.  We can implement savepoints on top of subtransactions, but not
vice versa.  AFAICS the savepoint syntax is just a shorthand for
a constrained form of subtransaction --- essentially one where you
can't explicitly commit a subtransaction, it's implicitly committed
when you commit the parent.  I don't see anything but syntactic
sugar here ...

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Nested transactions
Next
From: Bruce Momjian
Date:
Subject: Re: Tablespace patch review