Re: 024_add_drop_pub.pl might fail due to deadlock

Ajin Cherian <itsajin@gmail.com>

From: Ajin Cherian <itsajin@gmail.com>
To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
Cc: vignesh C <vignesh21@gmail.com>, Alexander Lakhin <exclusion@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>
Date: 2025-07-28T12:21:13Z
Lists: pgsql-hackers
On Fri, Jul 25, 2025 at 6:01 PM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
> Also, I'm now bit confusing for which branches are really affected. Can you
> create all patches for branches, attach at the same e-mail and add some summary
> what you want to fix?
> E.g., you provided a patch for HEAD/PG15/PG14, what about PG18, 17, 16 and 13?
> If not needed, why?

Yes, patches are needed for all  these versions except PG13 because
replicating origin is not there in PG13. If this logic is fine, I will
create patches for all these branches as well and send them tomorrow.

regards,
Ajin Cherian
Fujitsu Australia



Commits

  1. Fix a deadlock during ALTER SUBSCRIPTION ... DROP PUBLICATION.