Re: Rollback on Error - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Rollback on Error
Date
Msg-id 200410090032.i990WuK03240@candle.pha.pa.us
Whole thread Raw
In response to Re: Rollback on Error  ("Michael Paesold" <mpaesold@gmx.at>)
List pgsql-hackers
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,
thiswould allow errors in multi-statement transactions  to be automatically ignored.
 

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


pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: Inability to cast regclass is too restrictive
Next
From: Bruce Momjian
Date:
Subject: Re: more dirmod CYGWIN (was: APR 1.0 released)