On Wed, Apr 29, 2020 at 8:17 AM David Gauthier <davegauthierpg@xxxxxxxxx> wrote:
Check constraints:
"dvm_events_status_check" CHECK (status::text = ANY (ARRAY['passed'::character varying, 'failed'::character varying, NULL::character varying]::text[]))What could cause this ?
NULL in the array.
"status = NULL" yields NULL which is a pass for a check constraint.
David J.