Re: Skipping schema changes in publication - Mailing list pgsql-hackers

On Mon, Mar 9, 2026 at 8:22 AM vignesh C <vignesh21@gmail.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.

--
With Regards,
Amit Kapila.