Re: Allowing ALTER COLUMN TYPE for columns in publication column lists

Hi Soumya,

Thanks for testing. I had a look at the test failures, and after commit
67c20979 [1], a warning for creating a publication is only issued when the
wal_level is set to minimal. I've updated the test output to reflect this
and attached v2 of the patch.

Regards,
Kevin

[1]
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=67c20979ce72b8c236622e5603f9775968ff501c

On Mon, Jan 5, 2026 at 4:53 PM Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>
wrote:

> Hi,
>
> I tested this patch on my current branch.
> The patch applied cleanly and all relevant regression tests got
> passed, including publication, subscription, dependency, and ALTER
> TABLE coverage. The behavior matches the intended semantics: ALTER
> COLUMN TYPE is allowed for columns used only in publication column
> lists, while remaining blocked when the column is referenced in a row
> filter.
> I see a failure in the rules regression test in my environment, but
> this also occurs without the patch and this appears unrelated.
> From my testing, the patch looks correct and ready for further review.
> Please let me know if any further testing or clarification would be
> helpful.
>
>
> Regards
> Soumya
>