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