Thread: Re: Commit , Rollback

Re: Commit , Rollback

From
greg@turnstep.com
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

>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

I wrote a patch that does just this via a -b and \b option: anyone
is welcome to play with it:

http://www.gtsm.com/postgres.html

It is based on the latest cvs version of postgresql, so take care
if applying to an older version. If you have problems and need
a patch for an earlier version, let me know.

Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200202061602

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iQA/AwUBPGGbY7ybkGcUlkrIEQK/EwCgx0gzPhAzaYH9EDXjvMzbkdSDGHQAn2sl
cUkRmHT9plAIuuk1blD7wU2z
=jU3I
-----END PGP SIGNATURE-----