Re: BUG #2948: default null values for not-null domains

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergiy Vyshnevetskiy <serg(at)vostok(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2948: default null values for not-null domains
Date: 2007-01-31 18:33:56
Message-ID: 11211.1170268436@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Sergiy Vyshnevetskiy <serg(at)vostok(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergiy Vyshnevetskiy 2007-01-31 21:44:50 Re: BUG #2948: default null values for not-null domains
Previous Message Sergiy Vyshnevetskiy 2007-01-31 18:07:25 Re: BUG #2948: default null values for not-null domains