Re: savepoint improvements - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: savepoint improvements
Date
Msg-id 20070122190849.GO26006@alvh.no-ip.org
Whole thread Raw
In response to Re: savepoint improvements  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: savepoint improvements
List pgsql-hackers
Merlin Moncure wrote:
> On 1/22/07, Dawid Kuroczko <qnex42@gmail.com> wrote:

> >one for each INSERT+UPDATE block.  This way eiher both of them succeed
> >or fail, within one transaction.
> 
> i think so...Martijn said it best: you can 'rollback' to, but you
> can't 'commit' to.  The 'commit to' would be the arguably much more
> useful way of disposing of a savepoint.  But that should be taken up
> with sql standards committee :(.

You can RELEASE a savepoint though.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] Autovacuum Improvements
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] Autovacuum Improvements