Postgres Pro
Downloads
Home   >   mailing lists

Re: How to handle failed COMMIT - Mailing list pgsql-general

From David G. Johnston
Subject Re: How to handle failed COMMIT
Date
Msg-id CAKFQuwaAMjW940Zwjq1U+nBL6H_H_49i+18o5NujWKQ7yPgjBQ@mail.gmail.com
Whole thread Raw
In response to How to handle failed COMMIT  (Håvar Nøvik <havar@novik.email>)
Responses Re: How to handle failed COMMIT  (Håvar Nøvik <havar@novik.email>)
List pgsql-general
Tree view
On Monday, July 18, 2022, Håvar Nøvik <havar@novik.email> wrote:

try
   execute transactional sql
catch (commit failed)
   if (data is not stored)
     // regard data as not stored

Correct, the client did not get confirmation of commit success so it must operate as if it failed.

David J. 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: About limitation of using postgresql in china
Next
From: "David G. Johnston"
Date:
Subject: Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity