Postgres Pro
Downloads
Home   >   mailing lists

Re: "cancelling statement due to user request error" occurs but the transaction has committed. - Mailing list pgsql-hackers

From Naoya Anzai
Subject Re: "cancelling statement due to user request error" occurs but the transaction has committed.
Date
Msg-id 116262CF971C844FB6E793F8809B51C6BB521C@BPXM02GP.gisp.nec.co.jp
Whole thread Raw
In response to Re: "cancelling statement due to user request error" occurs but the transaction has committed.  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Allowing NOT IN to use ANTI joins
Next
From: Peter Eisentraut
Date:
Subject: Re: updated emacs configuration