Re: ALTER TABLE: warn when actions do not recurse to partitions - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: ALTER TABLE: warn when actions do not recurse to partitions
Date
Msg-id CAKFQuwahxpPKT-LXGJ34BO5cVBUxFxzgNPTY8E_VW-cuNU_DkQ@mail.gmail.com
Whole thread Raw
In response to Re: ALTER TABLE: warn when actions do not recurse to partitions  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: ALTER TABLE: warn when actions do not recurse to partitions
List pgsql-hackers
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 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.

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions
Next
From: "zengman"
Date:
Subject: Re: typedef indentation in pg_shmem.h