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 CAKFQuwZXt2dAuHFs6MtRCzfMP6YZFzssuzdW2woJBVmco=CDdQ@mail.gmail.com
Whole thread Raw
In response to 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
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:

For now, I’ve limited the change to REPLICA IDENTITY to see whether there are objections to this approach. If there are none, I plan to extend the same warning behavior to the other sub-commands listed above. After that, users can reasonably assume that an ALTER TABLE partitioned_table ... action will recurse to child partitions unless a warning explicitly tells them otherwise.

It should be a notice, not a warning.

How about indicating how many partitions were affected in the notice and allowing the absence of such a notice to be the indicator that cascading did not happen?

David J.

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: Robert Haas
Date:
Subject: Re: pg_plan_advice