-- Fail when attempting to insert a resolved ISOK_RESULTS row for an error
INSERT INTO isok_results (
    -- The irid is generated from a sequence
    iqname, first_seen, last_seen, last_role, last_schemas
  , resolved, deferred_to, category, keep_until
  , qr_id, qr_message, qr_extra
  , notes)
  VALUES ('errorquery2'
        , '1900-01-01'
        , '1900-01-01'
        , 'somerole'
        , '{"schema1","schema2"}'
        , '1900-01-01'
        , NULL
        , 'rtype1'
        , NULL
        , 'testresult2'
        , 'Informative message'
        , NULL
        , '');
ERROR:  Error on INSERT of ISOK_QUERIES
DETAIL:  Key (IRID) = (18): Value (IQName) = (errorquery2): Value (QR_ID) = (testresult2): Value (Resolved) = (Mon Jan 01 00:00:00 1900): The INTEGRITY_QUERY (errorquery2) produces errors, these may not be marked resolved
CONTEXT:  PL/pgSQL function isok_results_func() line 28 at RAISE