Re: Commit , Rollback

Поиск
Список
Период
Сортировка
От greg@turnstep.com
Тема Re: Commit , Rollback
Дата
Msg-id 200202062101.g16L0tE59097@postgresql.org
обсуждение исходный текст
Ответ на Commit , Rollback  ("Yogesh Kansal" <yogesh@davlin.co.in>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Indexs and prolems with.
Следующее
От: "Ian Harding"
Дата:
Сообщение: Re: [Fwd: MS SQL compatible functions]