Re: Questions about rollback and commit - Mailing list pgsql-general

From Richard Huxton
Subject Re: Questions about rollback and commit
Date
Msg-id 002701c10df2$2d1b5fe0$1001a8c0@archonet.com
Whole thread Raw
In response to Questions about rollback and commit  (Fariba Noorbakhsh <fNoorbakhsh@tecways.com>)
List pgsql-general
From: "Fariba Noorbakhsh" <fNoorbakhsh@tecways.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


pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: Nusphere/MySQL-AB arguing
Next
From: Vince Vielhaber
Date:
Subject: Re: ODBC driver for Mac?