Re: ALTER TABLE: warn when actions do not recurse to partitions

On Monday, January 12, 2026, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:

>
> Now, the message is like:
> ```
> evantest=# alter table sensor_data replica identity full;
> NOTICE: REPLICA IDENTITY does not apply to partitions (1 affected)
> ALTER TABLE
>

If it doesn't recurse there should be no count. It would either always be
1, so not helpful, or if did show a partition count, beside the point. In
the later case suppress the message if there are no partitions present.

The statement “does not apply to partitions” is also factually wrong. One
would just need to name the partition explicitly.

NOTICE: present partitions not affected
HINT: partitions may be modified individually using separate commands
ALTER TABLE

David J.