Questions about Rollback - after insert, update, delete ... operations?

From: Emi Lu <emilu(at)cs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Questions about Rollback - after insert, update, delete ... operations?
Date: 2005-09-22 19:20:17
Message-ID: 433303F1.40607@cs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-09-22 19:43:19 Re: Questions about Rollback - after insert, update,
Previous Message Jim C. Nasby 2005-09-22 19:15:13 Re: database update question