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 116262CF971C844FB6E793F8809B51C6BB6BDD@BPXM02GP.gisp.nec.co.jp
обсуждение исходный текст
Ответ на Re: "cancelling statement due to user request error" occurs but the transaction has committed.  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

> Well, the only other principled fix I can see is to add a new reponse
> along the lines of ERRORBUTITCOMMITTED, which does not seem attractive
> either, since all clients will have to be taught to understand it.

+1

I think current specification hard to understand for many users.
It is really good if PostgreSQL gave us a message such as a replication abort warning:
###
WARNING:  canceling wait for synchronous replication due to user request
DETAIL:  The transaction has already committed locally, but might not have been replicated to the standby.
###

Regards,

Naoya

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



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Audit of logout
Следующее
От: Jochem van Dieten
Дата:
Сообщение: Re: "RETURNING PRIMARY KEY" syntax extension