Re: Fix publisher-side sequence permission reporting

From: "Tristan Partin" <tristan(at)partin(dot)io>
To: "Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix publisher-side sequence permission reporting
Date: 2026-06-19 16:38:27
Message-ID: DJD69GFRSZ8G.27K1856EEDBF0@partin.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri Jun 19, 2026 at 9:16 AM CDT, Fujii Masao wrote:
> On Fri, Jun 19, 2026 at 8:11 AM Tristan Partin <tristan(at)partin(dot)io> wrote:
>> The patch looks good to me! I had one suggestion:
>>
>> > ##########
>> > # Ensure that insufficient privileges on the publisher for a sequence do not
>> > -# disrupt the subscriber. The subscriber should log a warning and continue
>> > -# retrying.
>> > +# get misreported as a missing sequence. The subscriber should log a warning
>> > +# and continue retrying.
>> > ##########
>>
>> I think a better comment might be:
>>
>> Ensure that insufficient privileges on the publisher for a sequence
>> are reported correctly...
>>
>> My reasoning for suggesting that is because your comment would to
>> indicate that any warning is accurate as long as it isn't related to
>> a missing sequence.
>
> Thanks for the review! I've updated the patch as suggested.
>
> Updated patches attached.

Looks great! Thanks for fixing this.

--
Tristan Partin
PostgreSQL Contributors Team
AWS (https://aws.amazon.com)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-06-19 16:52:37 Re: fix pg_mkdir_p to tolerate concurrent directory creation
Previous Message David G. Johnston 2026-06-19 15:51:22 Re: Fix \crosstabview to honor \pset display_true/display_false