Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner

[Zhijie Hou]

Hi,

On Wed, Oct 21, 2026 at 1:19 PM vignesh C <vignes...@gmail.com> wrote:
>
> On Tue, 20 Oct 2026 at 19:29, Zhijie Hou <houzhiji...@gmail.com> wrote:
> >
> > Agreed. Here is the new version that removes this.
>
> Thanks for the updated patch, the changes look good to me.
> Couple of minor suggestions:
> 1) The test passes without "ALTER SUBSCRIPTION regress_seq_sub REFRESH
> PUBLICATION WITH (copy_data = false);"
> +# Remove the dropped sequence (regress_s2) from the subscription, then 
> disable
> +# the subscription and wait for its workers to stop before changing its
> +# connection and owner.
> +$node_subscriber->safe_psql(
> +       'postgres', qq(
> +       ALTER SUBSCRIPTION regress_seq_sub REFRESH PUBLICATION WITH
> (copy_data = false);
>
> Not sure if this is required, even if required can we move this change
> along with the previous test as a test completion or cleanup.

Thanks for the comments.

This cleanup is to prevent the apply worker from repeatedly starting the
sequencesync worker for the missing sequence, which would pollute the logs
and delay the next worker launch. I moved it as suggested and added a brief
comment.

>
> 2) Similarly the test passes without "GRANT CREATE ON DATABASE
> postgres TO regress_seq_sub_owner;", I felt this is not required:

Agreed, this was a copy-paste oversight. Removed.

Attached is the v4 patch.

Best Regards,
Zhijie Hou

v4-0001-Add-error-context-for-sequence-synchronization.patch
Description: Binary data