> On 25 Oct 2023, at 13:39, Smolkin Grigory <smallkeen@gmail.com> wrote:
>
> We are running PG13.10 and recently we have encountered what appears to be a bug due to some race condition between
ALTERTABLE ... ADD CONSTRAINT and some other catalog-writer, possibly ANALYZ
> I've tried to reproduce this scenario with CREATE INDEX and various concurrent statements, but no luck.
Maybe it would be possible to reproduce with modifying tests for concurrent index creation. For example add “ANALYZE”
here[0].
Keep in mind that for easier reproduction it would make sense to increase transaction count radically.
Best regards, Andrey Borodin.
[0] https://github.com/postgres/postgres/blob/master/contrib/amcheck/t/002_cic.pl#L34