Re: 024_add_drop_pub.pl might fail due to deadlock - Mailing list pgsql-hackers

From Ajin Cherian
Subject Re: 024_add_drop_pub.pl might fail due to deadlock
Date
Msg-id CAFPTHDYfi_jpzMEHybsotjGsZdsDpesHxTki-LAT0e_5+nQr_A@mail.gmail.com
Whole thread Raw
In response to RE: 024_add_drop_pub.pl might fail due to deadlock  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Responses RE: 024_add_drop_pub.pl might fail due to deadlock
Re: 024_add_drop_pub.pl might fail due to deadlock
List pgsql-hackers
On Wed, Jul 23, 2025 at 8:01 PM Hayato Kuroda (Fujitsu)
<kuroda.hayato@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

Attachment

pgsql-hackers by date:

Previous
From: Nazir Bilal Yavuz
Date:
Subject: Re: Making type Datum be 8 bytes everywhere
Next
From: Andrei Lepikhov
Date:
Subject: Re: track generic and custom plans in pg_stat_statements