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

On Fri, Nov 13, 2026 at 3:16 AM Andrey Rachitskiy <pl0h0yp1(at)gmail(dot)com> wrote:
>
>
>
> чт, 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.
>

Thanks for the report and the patch. This appears to be the same issue
reported in [1]. Patch v2-0003 shared in [2] fixes it for ALL TABLES
publications, and also for the EXCEPT case, which is affected by the
same root cause.

[1] https://www.postgresql.org/message-id/CAN4CZFOxn6rv52YJRXE56sUx5iB-njB854o9jYLx2e-wO9hiAA%40mail.gmail.com
[2] https://www.postgresql.org/message-id/CADzfLwU97r3QC5oZDeVcWvcvXhNy9VnoFNDVHw%2BERg_DEG4%3DFQ%40mail.gmail.com

--
Thanks,
Nisha