Re: Allowing ALTER COLUMN TYPE for columns in publication column lists - Mailing list pgsql-hackers

From Kevin K Biju
Subject Re: Allowing ALTER COLUMN TYPE for columns in publication column lists
Date
Msg-id CAM45KeF9O8DmrahqHSRgzdNySkkT=F5aRXUSLU=-HVNggypntg@mail.gmail.com
Whole thread Raw
In response to Re: Allowing ALTER COLUMN TYPE for columns in publication column lists  (Soumya S Murali <soumyamurali.work@gmail.com>)
List pgsql-hackers
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.work@gmail.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
Attachment

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [PATCH] Expose checkpoint reason to completion log messages.
Next
From: Jakub Wartak
Date:
Subject: Re: Adding basic NUMA awareness