3 ms·
Ok, I have mine: When declare a custom type with a check, the error not show the row/table that cause the problem, only that something happen: CREATE DOMA
by mamcx 7y ago
Ok, I have mine:
When declare a custom type with a check, the error not show the row/table that cause the problem, only that something happen:
CREATE DOMAIN TEXTN AS TEXT
CONSTRAINT non_empty CHECK (length(VALUE) > 0);
However, doing the check inline show the error in full.
This cause me to rewrite all the tables, twice (one adding the new type thinking will help, once again inlining everything).