Cockroach: sql: support ALTER TABLE ALTER COLUMN SET NOT NULL

Created on 17 Aug 2018  路  9Comments  路  Source: cockroachdb/cockroach

This is distinct from #9851:

CockroachDB should be able to add the NOT NULL specifier on a column with ALTER, using a job that asserts that indeed no values are NULL.

A-schema-changes A-sql-pgcompat C-enhancement X-anchored-telemetry

Most helpful comment

All 9 comments

Ability to do this (w/o creating and moving data to a new column) would be appreciated!

We would also appreciate having this feature as we also run into this issue and ended up running without this constraint

@awoods187 ^^

Just came here to say +1 馃槃

cc @dt moving to schema change's project board.

+1

@joshimhoff how do you feel about a temporary solution of create table as?

@awoods187 LGTM, thx for pointer.

Was this page helpful?
0 / 5 - 0 ratings