> 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