Continue transactions after errors in psql
От | Greg Sabino Mullane |
---|---|
Тема | Continue transactions after errors in psql |
Дата | |
Msg-id | 1106708873.24449.2.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: Continue transactions after errors in psql
Re: Continue transactions after errors in psql Re: Continue transactions after errors in psql |
Список | pgsql-patches |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Attached is a patch that takes advantage of savepoints to enable transactions to continue even after errors in psql. The name of it is \reseterror, and it is off by default. It's backwards compatible, and allows things like this to work on 8.0 and up servers: \reseterror BEGIN; DELETE FROM foobar; INSERT INTO foobar(a) VALUES(1); ISNER INTO foobar(a) VALUES(2); INSERT INTO foobar(a) VALUES(3); COMMIT; Doing a SELECT(a) FROM foobar will show two values, 1 and 3. This is a great help for those of us that tend to type typos into our psql session, and end up cursing as we have to restart our current transaction. :) - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200501252203 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFB9wlpvJuQZxSWSsgRAsAzAKCxQ/JtR6/RXgV39uDTm9FIxCIp8QCeKC6T 2l10ef5DHkmFC2dSMQLNHjg= =HKv9 -----END PGP SIGNATURE-----
Вложения
В списке pgsql-patches по дате отправления: