Re: further clarification: alter table alter column set not null - table scan is skipped

I like your versions that emphasize: don’t drop the constraint in the same alter table set no null command. Similar to David’s point, I spent some time trying to figure out a simple refactoring to carry the optimization all the way to the end but it might require executing “set not null” sooner

Re: further clarification: alter table alter column set not null - table scan is skipped

released between phase 0 and 7. Sent from Yahoo Mail for iPhone On Monday, August 4, 2025, 04:32, Álvaro Herrera wrote: On 2025-Jul-31, Shuyu Pan wrote: > I like your versions that emphasize: don’t drop the constraint in the > same alter table set no null command.  Similar to David’s po