On Wed, Jul 23, 2025 at 8:01 PM Hayato Kuroda (Fujitsu) <kuroda.hay...@fujitsu.com> wrote: > > > Dear Ajin, > > > > Thanks for the patch. Firstly let me confirm my understanding. While > > altering the > > subscription, locks are acquired with below ordering: > > > > I forgot to confirm one point. For which branch should be backpatch? Initially > it was reported only on PG15 [1], but I found 021_alter_sub_pub could fail on > PG14.
Yes, here's a patch for PG14 as well, based on REL_14_STABLE. regards, Ajin Cherian Fujitsu Australia
PG_14-v4-0001-Fix-a-deadlock-during-ALTER-SUBSCRIPTION.-DROP-PU.patch
Description: Binary data