-- Fail upon insertion of a NULL ISOK_QUERIES.Keep INSERT INTO isok_queries ( iqname, error, type, keep -- , first_run, last_run , role, search_path, query, comment) VALUES('query2' , false , 'type1' , NULL , NULL , NULL , $$VALUES ('R4', 'Result number 4', NULL) , ('R5', 'Result number 5', NULL) , ('R6', 'Result number 6', NULL);$$ , 'No comment' ); ERROR: null value in column "keep" of relation "isok_queries" violates not-null constraint DETAIL: Failing row contains (query2, f, type1, null, null, null, null, null, VALUES ('R4', 'Result number 4', NULL) , ('R5', ..., No comment).