Re: Rollback on Error

Michael Paesold wrote:
> Alvaro Herrera Munoz wrote:
>
> > I think it would be wise to create a function to discover what savepoints
> > are available, and from that know when to release an automatically-
> > established savepoint.
> >
> > Of course, the function would only work when the backend is not in abort
> > state, but I think that's a reasonable restriction.
>
> Ok, that would need a set returning function in the backend, right? Could
> you help me write it when time comes? (I don't feel backend hacking savvy.)
>
> What about the resources consumed by savepoints
> a) that can be freed by a RELEASE (trx state stack, what else?)
> versus
> b) that cannot be freed (xid locks, anything else?)
>
> Is it worth the effort of extra work (not programmer's but runtime ;-)?
>
> Bruce,
> in Revision 1.1355 of the TODO you removed a line from the todo list that
> said:
> -Use nested transactions to prevent syntax errors from aborting a
> transaction
>
> I tought this is what I made a patch for, so shouldn't it be back for 8.1?
> Or at least something similar?

The item was adjusted to be more specific:

* Add an option to automatically use savepoints for each statement in a
multi-statement transaction.

When enabled, this would allow errors in multi-statement transactions
to be automatically ignored.

--
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