Re: Documenting when to retry on serialization failure

On Thu, 16 Dec 2021 at 06:05, Greg Stark <stark@mit.edu> wrote:

> So a lot of users are probably looking at something like "BEGIN;
> SELECT create_customer_order(....); COMMIT" and wondering why the
> server can't handle automatically retrying the query if they get an
> isolation failure.

I agree with you that it would be desirable to retry for the simple
case of an autocommit/single statement transaction run with
default_transaction_isolation = 'serializability'.

The most important question before we take further action is whether
this would be correct to do so, in all cases.

Some problem cases would help us decide either way.

-- 
Simon Riggs                http://www.EnterpriseDB.com/