RE: SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-15 Thread Takahashi, Ryohei
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

SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-14 Thread Takahashi, Ryohei
Hi, If application executes COMMIT statement and COMMIT failes because of PostgreSQL crash, it is unknown whether the transaction is really committed. Therefore, I think application should check the transaction is really committed after a while when certain SQLSTATE is returned. Which SQLSTATE