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 __/_/_//_/\_,_/ /_/\_\ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
