Re: idle-in-transaction timeout error does not give a hint
| От | Tatsuo Ishii |
|---|---|
| Тема | Re: idle-in-transaction timeout error does not give a hint |
| Дата | |
| Msg-id | 20181128.180617.1161250201215005974.t-ishii@sraoss.co.jp обсуждение исходный текст |
| Ответ на | RE: idle-in-transaction timeout error does not give a hint ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>) |
| Ответы |
RE: idle-in-transaction timeout error does not give a hint
|
| Список | pgsql-hackers |
> Hi, it makes sense to me. One can submit transaction again same as other cases
> you mentioned.
>
> I didn't attach the patch but according to my simple experiment
> in psql the output would become the following:
>
> FATAL: terminating connection due to idle-in-transaction timeout
> HINT: In a moment you should be able to reconnect to the
> database and repeat your command.
Alternative HINT message would be something like:
HINT: In a moment you should be able to reconnect to the
database and restart your transaction.
This could make the meaning of the error (transaction aborted)
cleaner and might give a better suggestion to the user.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: