Re: "cancelling statement due to user request error" occurs but the transaction has committed.

Поиск
Список
Период
Сортировка
От Naoya Anzai
Тема Re: "cancelling statement due to user request error" occurs but the transaction has committed.
Дата
Msg-id 116262CF971C844FB6E793F8809B51C6BB521C@BPXM02GP.gisp.nec.co.jp
обсуждение исходный текст
Ответ на Re: "cancelling statement due to user request error" occurs but the transaction has committed.  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hi Amit,
Thank you for your response.

> There can be similar observation if the server goes off (power
> outage or anything like) after committing transaction, client will
> receive connection broken, so he can misunderstand that as well.
> I think for such corner cases, client needs to reconfirm his action
> results with database before concluding anything.

I see.
Now, I understand that ProcessInterrupts Error (ProcDie, QueryCancel, ClientLost..) does not mean "That query has been
RollBacked".

Regards,

Naoya

---
Naoya Anzai
Engineering Department
NEC Solution Inovetors, Ltd.
E-Mail: anzai-naoya@mxu.nes.nec.co.jp
---



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Allowing NOT IN to use ANTI joins
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: updated emacs configuration