Re: savepoint improvements

On Mon, Jan 22, 2007 at 10:40:37AM -0500, Merlin Moncure wrote:
> The short version is I would like the ability to run some sql commands

<snip>

> any error updating foo or bar will blow up the whole thing.  Maybe
> this is desirable, but it is often nice to be able to do some error
> handling here.  In the pre-savepoint NT implementation I could:

<snip>

Nested transactions are trivially implemented on top of savepoints. If
we're talking about psql, maybe all we need to do is create the
commands in psql:

\begin_nest
\commit_nest
\rollback_nest

Would that suit your purpose?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.