Try:
begin;
update TABLE set FIELDx = VALUEy
rollback;
On Sat, Oct 13, 2001 at 12:02:01PM +0530, Mona wrote:
>
> We are trying to rollback an update in postgres. But so far we have not been able to do it.
> When we Rollback..
> it says:
>
> ROLLBACK: No transaction in progress.
>
> Same happens with commit.
> We are used to SQL PlUS
>
> Without these facilities we really cannot go ahead with postgres db. Could you please help us out on this.
--
patrick keshishian
Gnu __ _
-o)/ / (_)__ __ ____ __
/\\ /__/ / _ \/ // /\ \/ /
_\_v __/_/_//_/\_,_/ /_/\_\