Re: ALTER TABLE: warn when actions do not recurse to partitions
| От | David G. Johnston |
|---|---|
| Тема | Re: ALTER TABLE: warn when actions do not recurse to partitions |
| Дата | |
| Msg-id | CAKFQuwahxpPKT-LXGJ34BO5cVBUxFxzgNPTY8E_VW-cuNU_DkQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ALTER TABLE: warn when actions do not recurse to partitions (Chao Li <li.evan.chao@gmail.com>) |
| Ответы |
Re: ALTER TABLE: warn when actions do not recurse to partitions
|
| Список | 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 по дате отправления: