what happens if a failed transaction is not rolled back?

Поиск
Список
Период
Сортировка
От Siddharth Jain
Тема what happens if a failed transaction is not rolled back?
Дата
Msg-id CAPqV3pQms8Z5-v7vxZ9pRMxf7n0wOW+XUZ9cWjBP5=Fu=4_NFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: what happens if a failed transaction is not rolled back?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: what happens if a failed transaction is not rolled back?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: what happens if a failed transaction is not rolled back?  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
Hi All,

i understand when writing application code, we should rollback a transaction that fails to commit. this is typically done in the catch block of a try-catch exception handler. but what if the developer does not rollback the transaction? what happens in that case? 

note that i am not asking: what happens if a transaction is not rolled back?
i am asking: what happens if a failed transaction is not rolled back?

failed transaction = you try to commit it but get an exception back from the database.

thanks.

S.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question