Re: Commit , Rollback - Mailing list pgsql-general

From Doug McNaught
Subject Re: Commit , Rollback
Date
Msg-id m3u1su1t89.fsf@varsoon.denali.to
Whole thread Raw
In response to Re: Commit , Rollback  (Doug McNaught <doug@wireboard.com>)
List pgsql-general
"Yogesh Kansal" <yogesh@davlin.co.in> writes:

> no i want this while quering on the  prompt of psql ... actually i want a
> precautionary measure while doing updates , inserts or delete  to a table ..
> i want this so that i can roll back the whole transaction  if i make some
> mistake ..

Well, it can't be done without changing the code.  So change the code,
or live with it and remember to type BEGIN before you start working.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Chris Gamache
Date:
Subject: Re: 7.1.3 : copy from stdin is very slow!
Next
From: Tom Lane
Date:
Subject: Re: Problem with a view (not lazy ;)