Re: COMMIT after an ERROR?
| От | Charles Tassell |
|---|---|
| Тема | Re: COMMIT after an ERROR? |
| Дата | |
| Msg-id | 4.3.2.7.2.20011012160913.00c2be20@mailer.isn.net обсуждение исходный текст |
| Ответ на | COMMIT after an ERROR? (J C Lawrence <claw@kanga.nu>) |
| Ответы |
Re: COMMIT after an ERROR?
|
| Список | pgsql-general |
The failed query will abort the transaction, and throw out every command that comes before or after it until your rollback. You don't have to specifically issue a rollback unless you want to issue more commands though. When you disconnect from the DB it will automatically roll back the transaction.
At 05:18 AM 10/12/01, J C Lawrence wrote:
At 05:18 AM 10/12/01, J C Lawrence wrote:
Does an error during a transaction invalidate the transaction?
eg
BEGIN
SomeQueryThatSucceeds
SomeQueryThatFails
SomeOtherQueryThatSucceeds
COMMIT
Will the transaction successfully COMMIT, or will the COMMIT fail?
Translation: Do I need to monitor for error conditions during a
transaction and manually do the ROLLBACK in those cases?
--
J C Lawrence
---------(*) Satan, oscillate my metallic sonatas.
claw@kanga.nu He lived as a devil, eh?
http://www.kanga.nu/~claw/ Evil is a name of a foeman, as I live.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
В списке pgsql-general по дате отправления: