On 05/12/2018 08:47 PM, Bruce Momjian wrote: > On Sat, May 12, 2018 at 01:22:55PM -0700, Peter Geoghegan wrote: >> On Fri, May 11, 2018 at 2:06 PM, Bruce Momjian <br...@momjian.us> wrote: >>> Done and URL updated. >> I have some feedback on "Allow NOT NULL to be added to columns without >> requiring a table rewrite". I suggest that this be phrased as "Avoid a >> table rewrite when ALTER TABLE ADD COLUMN sets a default value for a >> column". Referencing the fact that Postgres was previously able to do >> this with a NULL default doesn't seem to add anything. > Agreed, done: > > Allow <command>ALTER TABLE</command> to add a non-null default > column without a table rewrite (Andrew Dunstan, Serge Rielau) >
I think "a column with a non-null default" would be a bit clearer than "a non-null default column". cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
