Re: idle-in-transaction timeout error does not give a hint - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: idle-in-transaction timeout error does not give a hint
Date
Msg-id 20181203.130345.1717864333333955756.t-ishii@sraoss.co.jp
Whole thread Raw
In response to RE: idle-in-transaction timeout error does not give a hint  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
Responses RE: idle-in-transaction timeout error does not give a hint  ("Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>)
List pgsql-hackers
>>>>>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.

>>BTW, would you like to be added to the CF item as a reviewer?
> Yeah, I've already added myself as a review.

Thanks.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: AllocSetContextCreate changes breake extensions
Next
From: John Naylor
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables