Re: Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Laurenz Albe
On Thu, 2023-02-09 at 10:45 -0500, Kiriakos Georgiou wrote: > I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I > can summarize with this test scenario: > > /**/ > > — suppose we have this table and in

Re: Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Kiriakos Georgiou
wrote: > > Hello, > > I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I > can summarize with this test scenario: > > /**/ > > — suppose we have this table and index > create table test(x

Re: Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Adrian Klaver
On 2/9/23 07:45, Kiriakos Georgiou wrote: Hello, I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I can summarize with this test scenario: /**/ — suppose we have this table and index create table test(x int); create

Concurrency issue with DROP INDEX CONCURRENTLY

2023-02-09 Thread Kiriakos Georgiou
Hello, I have an interesting concurrency issue with DROP INDEX CONCURRENTLY that I can summarize with this test scenario: /**/ — suppose we have this table and index create table test(x int); create index idx1 on test(x); — now suppose with the