ERROR: domain dnotnulltest does not allow null values

alter domain dnotnulltest drop not null;

update domnotnull set col1 = null;

update domnotnull set col1 = 5;

-- these constraints can also be added and removed by name

alter domain dnotnulltest add constraint dnotnulltest_notnull not null;

update domnotnull set col1 = null;-- fails

ERROR: domain dnotnulltest does not allow null values

select conname, pg_get_constraintdef(oid) from pg_constraint

where contypid = 'dnotnulltest'::regtype;

conname | pg_get_constraintdef

----------------------+----------------------

dnotnulltest_notnull | NOT NULL

(1 row)

alter domain dnotnulltest drop constraint dnotnulltest_notnull;

update domnotnull set col1 = null;

drop domain dnotnulltest cascade;

NOTICE: drop cascades to 2 other objects

DETAIL: drop cascades to column col2 of table domnotnull

update domnotnullset col1=null;

update domnotnullset col1=5;

alterdomain dnotnulltest addconstraint dnotnulltest_notnullnot null;

update domnotnullset col1=null;-- fails

select conname, pg_get_constraintdef(oid)from pg_constraint

where contypid='dnotnulltest'::regtype;

alterdomain dnotnulltest dropconstraint dnotnulltest_notnull;

update domnotnullset col1=null;

dropdomain dnotnulltest cascade;