| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | vignesh C <vignesh21(at)gmail(dot)com> |
| Cc: | Andrei Lepikhov <lepihov(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, YeXiu <1518981153(at)qq(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Skipping schema changes in publication |
| Date: | 2026-03-09 07:34:45 |
| Message-ID: | CAA4eK1LoAqAkLqAM1C=LV1LcacPR-4pe58AZYOAp9F8c+fYKnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
--
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wenhui qiu | 2026-03-09 07:38:11 | Re: Convert NOT IN sublinks to anti-joins when safe |
| Previous Message | Nisha Moond | 2026-03-09 07:00:42 | Re: Skipping schema changes in publication |