Re: sequencesync worker race with REFRESH SEQUENCES

From: vignesh C <vignesh21(at)gmail(dot)com>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sequencesync worker race with REFRESH SEQUENCES
Date: 2026-07-21 05:34:23
Message-ID: CALDaNm3MHsVJiW1mfzAX_n7bQvrvpR_D+xKNRCGOuToDoXhE2A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 21 Jul 2026 at 10:48, Hayato Kuroda (Fujitsu)
<kuroda(dot)hayato(at)fujitsu(dot)com> wrote:
>
> My assumption was that the connection was not so heavy operation.
> If it's not correct, yes the connection should be established later.

FYI, the v3-0002 patch from [1], which fixes this issue, applies
cleanly to both the master and PG19 branches. I'm re-attaching the
same patch here to make it easier for reviewers to access and review
it.

[1] - https://www.postgresql.org/message-id/CALDaNm0wi5XxbHsmKT%2BphLHwV%3DNtUeFeCpiKkjx29RanJjJ7UQ%40mail.gmail.com

Regards,
Vignesh

Attachment Content-Type Size
v3-0002-Reject-changing-subscriptions-with-sequences-to-p.patch application/octet-stream 10.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-07-21 05:42:11 Re: Support EXCEPT for TABLES IN SCHEMA publications
Previous Message Hayato Kuroda (Fujitsu) 2026-07-21 05:18:32 RE: sequencesync worker race with REFRESH SEQUENCES