Hi Francisco and Andreas, Thank you for your reply. > So, if the library gives you an error ( "I have not received the commit > confirmation" , not something like "commit failed" ), you will still > need to test the data, if you can, to know how the server come back up. Yes. I want to know what error does library give to the application on such case. I supposed it is certain SQLSTATE. > since pg10 you can use check the status of a transaction, here is a > explanation: > https://blog.2ndquadrant.com/postgresql-10-transaction-traceability/ Thank you for the information. According to the page and the PostgreSQL documentation of txid_status(), the application should look up the transaction's completion status when the connection is lost, not when certain SQLSTATE is given, right? Regards, Ryohei Takahashi
