On Wed, Apr 29, 2020 at 8:17 AM David Gauthier <davegauthierpg(at)gmail(dot)com>
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.