In #51 we allowed setting a non-volatile default when adding adding a
new column on PG11+. In the same situation we can also allow NOT NULL
since the application of a non-volatile and non-null default value
necessarily implies the column is NOT NULL (requiring no table scan --
which, while not clear in the commit message of the PG11 commit adding
this feature, we confirmed by checking the seq_scan stats count on a
test table).
In #51 we allowed setting a non-volatile default when adding adding a new column on PG11+. In the same situation we can also allow
NOT NULL
since the application of a non-volatile and non-null default value necessarily implies the column is NOT NULL (requiring no table scan -- which, while not clear in the commit message of the PG11 commit adding this feature, we confirmed by checking the seq_scan stats count on a test table).Co-authored-by: Jonathan Lukens jonathan.lukens@gmail.com