Questions about Rollback - after insert, update, delete ... operations? - Mailing list pgsql-general

From Emi Lu
Subject Questions about Rollback - after insert, update, delete ... operations?
Date
Msg-id 433303F1.40607@cs.concordia.ca
Whole thread Raw
Responses Re: Questions about Rollback - after insert, update,
Re: Questions about Rollback - after insert, update, delete ... operations?
List pgsql-general
greetings,

I remembered I read something in the mailing list about "*rollback*" a
while ago. People mentioned that some operations cannot rollback.
I cannot remember what kinds of perations are not be able to rollback?

For example,

begin
    ... ...
    insert
    ... ...
    delete
    ... ...
    update
    ... ...

    /* If any of the above operation failed, we can rollback all the
above operations? */
    rollback
    ... ...
end


Will all "Insert, delete, update" operations rollback if any of the
operations fails?

Thanks a lot!
Emi

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: database update question
Next
From: Scott Marlowe
Date:
Subject: Re: Questions about Rollback - after insert, update,