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/
