On Monday, January 12, 2026, Chao Li <li.evan.chao@gmail.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 count was real. I agree that we can suppress the message when there are no partitions. Addressed that in v3.
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
Thanks for the suggestion, I took that in v3.
PSA v3:
* Rephrased the notice message as David's suggestion.
* Removed partition count from notice message.
* If a partitioned table doesn't have any partition, then suppress the message.
Now the command outputs look like:
```
evantest=# alter table sensor_data replica identity full;
NOTICE: present partitions not affected
HINT: partitions may be modified individually using separate commands
ALTER TABLE
```
Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
