On Thu, 15 Nov 2001, Christopher Kings-Lynne wrote:
> I have noticed a strange error message when adding check constraints.
> Basically the ADD CHECK below is failing because the field it is trying to
> force to be NOT NULL already has NULL values in it. However, the error
> message it produces is quite cryptic and it took me a while to figure out
> what was going on.
>
> Is it still like this in 7.2b2, and should it be changed?
Pretty sure and possibly. In general, the message is currently
based on the same template as the error you get if you were to
fail it later. I don't have a good phrase to replace it with,
but a more descriptive message would probably be good.