Daniel Einspanjer <deinspanjer(at)gmail(dot)com> writes:
> Tom, please forgive me if this is a non-starter for a suggestion, but what
> about forcing a not null constraint on a column that is declared to be of
> the type of a domain that has a not null constraint?
I don't particularly want to go there. What happens when you add or drop
the not null constraint on an existing domain type?
In any case, this would amount to positive reinforcement for people who
use domain not null constraints, which IMO is bad practice to start with.
Not everything in the SQL standard is a good idea.
regards, tom lane