Re: BUG #19884: pg_publication_tables omits a detach-pending partition in root mode

чт, 12 нояб. 2026 г. в 22:16, PG Bug reporting form <noreply(at)postgresql(dot)org
>:

> The following bug has been logged on the website:
>
> Bug reference: 19884
> Logged by: Milo
> Email address: 1548140642(at)qq(dot)com
> PostgreSQL version: 18.6
> Operating system: Linux/amd64
> Description:
>
> After phase one of ALTER TABLE ... DETACH PARTITION CONCURRENTLY,
> pg_publication_tables omits the detach-pending child from an ALL TABLES
> publication when publish_via_partition_root is enabled. At that point the
> child has no ancestors and is treated as a standalone relation for
> publication purposes, so it should appear in the view. The query instead
> returns zero rows.
>
>
>
Hi Milo!

Thanks for the report.

I was also able to reproduce the problem on the master branch.

I think we can fix this by using get_partition_ancestors() in
pg_get_publication_tables().
After the pending detach commits, that list is empty, so the table stays in
the publication.

Patch in attachment.

Sawada-san in CC

--
Regards,
Rachitskiy Andrey