Re: BUG #2948: default null values for not-null domains - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2948: default null values for not-null domains
Date
Msg-id 11211.1170268436@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2948: default null values for not-null domains  (Sergiy Vyshnevetskiy <serg@vostok.net>)
Responses Re: BUG #2948: default null values for not-null domains  (Sergiy Vyshnevetskiy <serg@vostok.net>)
Re: BUG #2948: default null values for not-null domains  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
Sergiy Vyshnevetskiy <serg@vostok.net> writes:
> This should fix the problem.

No, not at all.  Consider if you'd written a domain CHECK constraint
that rejects nulls, instead of the easy case.  What we'd really have
to do here is see if domain_in() will accept a NULL.

I'm starting to get the feeling that the entire idea of NOT NULL domains
is broken :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: Sergiy Vyshnevetskiy
Date:
Subject: Re: BUG #2948: default null values for not-null domains
Next
From: Sergiy Vyshnevetskiy
Date:
Subject: Re: BUG #2948: default null values for not-null domains