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

From: Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>
To: Kevin K Biju <kevinkbiju(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Allowing ALTER COLUMN TYPE for columns in publication column lists
Date: 2026-01-05 11:23:53
Message-ID: CAMtXxw_JwOQHeH6B8wkNFG=VJ3HZaHTSFdFgWJGQgRmH6c=rJQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message ls7777 2026-01-05 11:27:26 Re: Patch for migration of the pg_commit_ts directory
Previous Message Amit Kapila 2026-01-05 11:18:50 Re: Proposal: Conflict log history table for Logical Replication