
CREATE OR REPLACE PROCEDURE haf_admin_test_given()
        LANGUAGE 'plpgsql'
    AS
$BODY$
BEGIN
    -- query shall not be broken
    CREATE TABLE numbers( num INT );
    INSERT INTO numbers SELECT generate_series(1,10000);
END
$BODY$
;


CREATE OR REPLACE PROCEDURE haf_admin_test_when()
LANGUAGE 'plpgsql'
AS
$BODY$
BEGIN
    -- to check if other types of queries do not interfere
    -- we can set because haf_admin is a superuser
    SET query_supervisor.limit_selects TO 1;
    SET query_supervisor.limit_updates TO 1;
    SET query_supervisor.limit_inserts TO 1;

    -- default value for a limit is 1000 rows, here we will modify 10.000, so limit is reached
    DELETE FROM numbers;
END
$BODY$
;





