> On Oct 23, 2026, at 02:36, surya poondla <[email protected]> wrote:
>
>
> Hi Peter,
>
> I looked at v3. I agree ONLY/* have no effect for partitioned tables in every
> ALTER PUBLICATION variant i.e OpenTableList() skips recursion
> for RELKIND_PARTITIONED_TABLE regardless of ADD/SET/DROP/EXCEPT.
>
> A few points,
>
> 1. Following on from Fujii's point that table_name in ALTER PUBLICATION also
> covers DROP, the new note explains ONLY/* only in
> terms of adding, which leaves DROP unclear. For example:
>
> CREATE TABLE p (id int) PARTITION BY RANGE (id);
> CREATE TABLE p1 PARTITION OF p FOR VALUES FROM (0) TO (100);
> CREATE PUBLICATION c FOR TABLE p, p1;
> ALTER PUBLICATION c DROP TABLE p *;
> -- p1 remains in pg_publication_rel
>
> whereas for a plain inheritance parent, DROP TABLE parent (without ONLY) also
> removes the child. Maybe worth saying that dropping a
> partitioned table does not remove partitions that were added to the
> publication explicitly.
>
I don’t think this is a normal usage that we want to prompt. I’m afraid that
describing details of such an edge case may just make users confused. In the
meantime, I would challenge if that’s a bug. IMO, dropping “p *” should drop p1.
Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/
