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 should application check? Or, is there any document which is 
written about this?

In my observation, ecpg returns '57P02' and libpq returns 'null' when 
PostgreSQL crashes during COMMIT statement.
Any other SQLSTATE?


Regards,
Ryohei Takahashi





Reply via email to