Re: How to handle failed COMMIT

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Håvar Nøvik <havar(at)novik(dot)email>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to handle failed COMMIT
Date: 2022-07-19 14:12:46
Message-ID: CAKFQuwaAMjW940Zwjq1U+nBL6H_H_49i+18o5NujWKQ7yPgjBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday, July 18, 2022, Håvar Nøvik <havar(at)novik(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-07-19 14:19:18 Re: pgsql 10.19 : "ERROR: cannot convert infinity to numeric" except there is no infinity
Previous Message Robert Haas 2022-07-19 13:56:41 Re: [PATCH] Introduce array_shuffle() and array_sample()