-- Fail inserting a NULL value into ISOK_RESULTS.QR_Message 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' , '{"schema1","schema2"}' , NULL , NULL , 'rtype1' , NULL , 'testresult2' , NULL , NULL , ''); ERROR: null value in column "qr_message" of relation "isok_results" violates not-null constraint DETAIL: Failing row contains (11, query1, Mon Jan 01 00:00:00 1900, Mon Jan 01 00:00:00 1900, somerole, {schema1,schema2}, null, null, rtype1, null, testresult2, null, null, ).