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

From David G. Johnston
Subject Re: How to handle failed COMMIT
Date
Msg-id CAKFQuwbBjVsEcedoPzLyb9WvAKgJBYwg6-8XQ218aJqExuNWfg@mail.gmail.com
Whole thread Raw
In response to How to handle failed COMMIT  (Håvar Nøvik <havar@novik.email>)
List pgsql-general
On Tuesday, July 19, 2022, Håvar Nøvik <havar@novik.email> wrote:
> Correct, the client did not get confirmation of commit success so it must operate as if it failed.

I mean that’s the point, the client can’t operate as if it failed. It must operate as the state is unknown. But maybe that’s the correct application behaviour, just that I haven’t thought this through previously.

Right, since you sent commit there is now a non-zero chance the data is committed but the client is unaware of that fact.

David J.

pgsql-general by date:

Previous
From: Håvar Nøvik
Date:
Subject: Re: How to handle failed COMMIT
Next
From: Adrian Klaver
Date:
Subject: Re: Out Of Memory