On Thu, 16 Dec 2021 at 06:05, Greg Stark <st...@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/