Re: Commit , Rollback - Mailing list pgsql-general

From greg@turnstep.com
Subject Re: Commit , Rollback
Date
Msg-id 200202062101.g16L0tE59097@postgresql.org
Whole thread Raw
In response to Commit , Rollback  ("Yogesh Kansal" <yogesh@davlin.co.in>)
List pgsql-general
-----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-----



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Indexs and prolems with.
Next
From: "Ian Harding"
Date:
Subject: Re: [Fwd: MS SQL compatible functions]