Re: SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-16 Thread Tom Lane
"Takahashi, Ryohei" writes: >> 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

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

Re: SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-15 Thread Andreas Kretschmer
Am 15.04.19 um 12:41 schrieb Francisco Olarte: On Mon, Apr 15, 2019 at 4:11 AM Takahashi, Ryohei wrote: 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 ch

Re: SQLSTATE when PostgreSQL crashes during COMMIT statement

2019-04-15 Thread Francisco Olarte
On Mon, Apr 15, 2019 at 4:11 AM Takahashi, Ryohei wrote: > 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 af