-- Fail inserting a NULL value into ISOK_RESULTS.Last_Schemas INSERT INTO isok_results ( iqname, first_seen, last_seen, last_role, last_schemas , resolved, deferred_to, category, keep_until , qr_id, qr_message, qr_extra , notes) VALUES ('query1' , '1900-01-01' , '1900-01-01' , 'somerole' , NULL , NULL , NULL , 'rtype1' , NULL , 'testresult2' , 'Informative message' , NULL , ''); ERROR: null value in column "last_schemas" of relation "isok_results" violates not-null constraint DETAIL: Failing row contains (6, query1, Mon Jan 01 00:00:00 1900, Mon Jan 01 00:00:00 1900, somerole, null, null, null, rtype1, null, testresult2, Informative message, null, ).