On Mon, 9 Mar 2026 at 13:04, Amit Kapila <[email protected]> wrote: > > On Mon, Mar 9, 2026 at 8:22 AM vignesh C <[email protected]> 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
v60-0001-Support-SET-ALL-TABLES-EXCEPT-TABLE-in-ALTER-PUB.patch
Description: Binary data
