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.