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 ..
thanks for reply.
yogesh
> "Yogesh Kansal" <yogesh@davlin.co.in> writes:
>
> > Hi List ,
> > Could any one of you help me in finding out a way by which
> > 1)when i login to postgres "begin transaction " command automatically
> > executes .
> > 2)i write commit it should commit as well as begin the new transaction .
> > 3) similarly with rollback.
>
> Do it at the application level.
>
> -Doug
> --
> Let us cross over the river, and rest under the shade of the trees.
> --T. J. Jackson, 1863
>
--
Walking on water and developing software from a specification are easy if
both are frozen."
-- Edward V. Berard, "Life-Cycle Approaches"