Re: Moving to postgresql and some ignorant questions - Mailing list pgsql-general

> You could do this with savepoints which are a kind of sub-transaction inside a
> "bigger" transaction.
>
> e.g.:
> BEGIN TRANSACTION;
>
> SAVEPOINT sp1;
> UPDATE1;
> IF (failed) rollback to savepoint sp1;
>
> SAVEPOINT sp1;
> UPDATE2;
> IF (failed) rollback to savepoint sp2;



Thanks Thomas, this is a great feature even if I am not looking for it
right now, I bet I can use it at some point!