Luke Pascoe <luke(dot)p(at)kmg(dot)co(dot)nz> wrote:
> temp=> ALTER TABLE Parent ADD CONSTRAINT ddd_nn CHECK (ddd IS NOT
> NULL); ERROR: AlterTableAddConstraint: rejected due to CHECK
> constraint ddd_nn
>
> Why can't I add this check to the Parent table?
>
Try "CHECK (NOT (ddd IS NULL))" or "CHECK (NOT ddd IS NULL)" instead...
It might be some interpretation differances between your head and pgsql
:)
I know i have these types of constraints myself, i can dig up the
specifics if the above doesn't work.
Cheers
Magnus