Re: savepoint improvements - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: savepoint improvements
Date
Msg-id b42b73150701220821g7eedbf3doc723f70ea22eb256@mail.gmail.com
Whole thread Raw
In response to Re: savepoint improvements  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: savepoint improvements
List pgsql-hackers
On 1/22/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
> we're talking about psql, maybe all we need to do is create the
> commands in psql:
>
> \begin_nest
> \commit_nest
> \rollback_nest

That would work if we could rollback conditionally on failure (like
on_error_rollback but with definable beginning and ending points).  I
still think we are hacking around limitations of savepoints but it
would solve the scripting problem at least.  A general implementation
on the server would benefit everybody.

merlin


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: pg_dump ANALYZE statements
Next
From: "Simon Riggs"
Date:
Subject: Re: savepoint improvements