Re: Commit , Rollback

From: Doug McNaught <doug(at)wireboard(dot)com>
To: yogesh(at)davlin(dot)co(dot)in
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Commit , Rollback
Date: 2002-02-06 16:16:06
Message-ID: m3u1su1t89.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Yogesh Kansal" <yogesh(at)davlin(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F. O'Connell 2002-02-06 16:31:44 Re: newbie: Creating a function
Previous Message Chris Gamache 2002-02-06 16:13:51 Re: 7.1.3 : copy from stdin is very slow!