RE: idle-in-transaction timeout error does not give a hint

Поиск
Список
Период
Сортировка
От Ideriha, Takeshi
Тема RE: idle-in-transaction timeout error does not give a hint
Дата
Msg-id 4E72940DA2BF16479384A86D54D0988A6F3C2DA3@G01JPEXMBKW04
обсуждение исходный текст
Ответ на Re: idle-in-transaction timeout error does not give a hint  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: idle-in-transaction timeout error does not give a hint  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
>From: Tatsuo Ishii [mailto:ishii@sraoss.co.jp]
>Subject: Re: idle-in-transaction timeout error does not give a hint
>
>>>>>>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.
>>>>>
>>>>> Agreed. Changing "command" to "transaction" seems more accurate.
>>>>> People might think only the command they hit is not sent but
>>>>> transaction is still alive though it's of course unnatural that
>>>>> transaction is alive after
>>>connection is terminated.
>>
>>
>>>Please find attached patch which addresses the point above.
>> Thank you for the update. It looks good to me on this point.
>> Are you planning to change other similar messages?
>
>No, because this is the only message related to an explicit transaction.  Other
>messages are not related to explicit transactions, so current messages look ok to me.

Sure. I didn't have a strong opinion about it, so it's ok.

Regards,
Takeshi Ideriha



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [Todo item] Add entry creation timestamp column topg_stat_replication
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Making all nbtree entries unique by having heap TIDs participatein comparisons