when transaction is committed in postgres - Mailing list pgsql-sql

From abctevez
Subject when transaction is committed in postgres
Date
Msg-id 3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com
Whole thread Raw
List pgsql-sql
      Hello,I read the introduction of transaction on the postgresql official website. It notes that transaction is committed when commit call.
      Suppose that , I execute begin、execute command and then commit using some postgres client such as jdbc or odbc, what happens if the postgresql server receive commit command and response commit message failure,like tcp shakehand?If it is still to be committed, the client has no way to know whether the transaction is committed successfully or not.How does postgresql handle such situation

Thanks advances
Richard


 



 

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: does the notification of postgres appear in transaction completed order
Next
From: Jasmin Dizdarevic
Date:
Subject: select unnest(), unnest()