Re: [PATCH] Fix alter subscription concurrency errors - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: [PATCH] Fix alter subscription concurrency errors
Date
Msg-id CAA4eK1L1Si=SpUW_2DKz2fHZEioKXOBe0vj5QqyOdwnW1B27yg@mail.gmail.com
Whole thread Raw
In response to [PATCH] Fix alter subscription concurrency errors  (Jelte Fennema <Jelte.Fennema@microsoft.com>)
Responses Re: [PATCH] Fix alter subscription concurrency errors
List pgsql-hackers
On Thu, Aug 25, 2022 at 8:17 PM Jelte Fennema
<Jelte.Fennema@microsoft.com> wrote:
>
> Without this patch concurrent ALTER/DROP SUBSCRIPTION statements for
> the same subscription could result in one of these statements returning the
> following error:
>
> ERROR:  XX000: tuple concurrently updated
>
> This patch fixes that by re-fetching the tuple after acquiring the lock on the
> subscription. The included isolation test fails most of its permutations
> without this patch, with the error shown above.
>

Won't the same thing can happen for similar publication commands? Why
is this unique to the subscription and not other Alter/Drop commands?

-- 
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [PATCH] Add native windows on arm64 support
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: pg_stat_wal: tracking the compression effect