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.