Re: Publication DDL can race with a concurrent UPDATE

From: vignesh C <vignesh21(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Publication DDL can race with a concurrent UPDATE
Date: 2026-10-01 10:53:20
Message-ID: CALDaNm3d5ZH_TZvAZMMLwVB1hBHRSDe3JvczX1j3RLRB57aKHg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 29 Sept 2026 at 15:41, vignesh C <vignesh21(at)gmail(dot)com> wrote:
>
> The attached POC demonstrates the changes for the same.

Here is the updated v2 patch, which addresses Hou-san's comment at [1]
regarding concurrent UPDATE/DELETE with ALTER PUBLICATION SET
(options).

[1] - https://www.postgresql.org/message-id/TY4PR01MB17718FD116A2C749F35D28FD094B12%40TY4PR01MB17718.jpnprd01.prod.outlook.com

Regards,
Vignesh

Attachment Content-Type Size
v2-0002-Concurrent-UPDATE-DELETE-with-the-following-CREAT.patch application/octet-stream 21.0 KB
v2-0001-Lock-tables-against-writers-when-altering-their-p.patch application/octet-stream 10.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nisha Moond 2026-10-01 11:08:40 Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation
Previous Message Zhijie Hou 2026-10-01 10:45:54 Re: Fix apply worker crash when subscriber table has only a deferrable primary key