From: "Fariba Noorbakhsh" <fNoorbakhsh(at)tecways(dot)com>
> I tried Rollback after update or insert, but it doesn't work!
> How can I rollback the update, insert or delete changes I have made in
> pgsql?
> Do I need to do commit after each update or insert?
> Do update, insert or delete consider as transactions?
By default, every SQL statement is wrapped in its own transaction. You'll
need to issue a BEGIN if you want to be able to ROLLBACK.
HTH
- Richard Huxton