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

On Thu, Mar 5, 2026 at 5:22 PM shveta malik <shveta.malik@gmail.com> wrote:
>
> 2)
> postgres=# ALTER TABLE tab_top_root ATTACH PARTITION tab_root FOR
> VALUES FROM (0) TO (2000);
> ERROR:  cannot attach table "tab_root" as partition because it is
> referenced in publications "pub1", "pub3" EXCEPT clause
> DETAIL:  The publication EXCEPT clause cannot contain tables that are
> partitions.
> HINT:  Modify the publication's EXCEPT clause using ALTER PUBLICATION
> ... SET EXCEPT TABLE or DROP EXCEPT TABLE before attaching the table.
>
> Shall we shorten the HINT slightly? Is it necessary to explicitly say
> "before attaching the table", or can we omit it? Thoughts?
>

I think we can omit it.

--
With Regards,
Amit Kapila.