-- Fail inserting string of just whitespace into ISOK_RESULTS.QR_ID 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 , ' ' , 'Informative message' , NULL , ''); ERROR: new row for relation "isok_results" violates check constraint "QR_ID: Cannot be empty or only whitespace characters" DETAIL: Failing row contains (10, query1, Mon Jan 01 00:00:00 1900, Mon Jan 01 00:00:00 1900, somerole, {schema1,schema2}, null, null, rtype1, null, , Informative message, null, ).