Re:

Hi Mona,
you have to start transaction firstly,
testdb=#begin;
,then do some select, insert, update etc., then
testdb=#rollback;
or
testdb=#commit;

all commands outside transaction are autocommited.

pajout

Mona wrote:

> Hi
>
>
>
>
> 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.
>
>
>
>
>
>
>
> Thanks
>
> mlisa
>