Re: Skipping schema changes in publication

On Mon, 9 Mar 2026 at 13:04, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Mon, Mar 9, 2026 at 8:22 AM vignesh C <vignesh21(at)gmail(dot)com> wrote:
> >
> > The attached v59 patch has the changes to update the syntax accordingly.
> >
>
> Creation of FOR ALL TABLES publications requires superuser privileges.
> See following code in CreatePublication()
>
> ---
> /* FOR ALL TABLES and FOR ALL SEQUENCES requires superuser */
> if (!superuser())
> {
> if (stmt->for_all_tables || stmt->for_all_sequences)
> ereport(ERROR,
> errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
> errmsg("must be superuser to create a FOR ALL TABLES or ALL SEQUENCES
> publication"));
> }
> ---
>
> Similarly, won't altering them also require the superuser privilege? I
> don't see the corresponding code in the patch.

This is addressed in the v60 version patch attached.
Also Nisha's comments from [1] and Shveta's comments from [2] are
handled in the v60 version.

[1] - https://www.postgresql.org/message-id/CABdArM65WySkXh0KSTdpX2cxKEPBdGGTt693vhpgAdW-uH97JQ%40mail.gmail.com
[2] - https://www.postgresql.org/message-id/CAJpy0uAWyaorY4NzreVM5hURQYY7hKpj%3Dc8dWziF3GBkFDvLJw%40mail.gmail.com

Regards,
Vignesh