Hi

> Yes - the check is done before the insert. It should succeed with this

script and fail next time you insert any *value* at all into id.

I would consider this a bug.
What is the sense of having CHECK-constraints when I can create data, which
fails that check?
Exspecially since vialoations are thrown at points, where the data is
already invalid.
I expected it to fail on insert to allow exception-handlers to take care of
it or at least to auto-rollback these changes.
How shall I know, what to correct, if I get that error on the next
(unrelated) insert?

Regards,
Steffen


[Non-text portions of this message have been removed]