CREATE TABLE sro_table0 (s varchar);
CREATE TABLE sro_table1 (s varchar);
CREATE TABLE sro_table_exp (a int, b int);

CREATE OR REPLACE FUNCTION sro_activity1(integer) RETURNS integer
   LANGUAGE sql IMMUTABLE AS
'SELECT $1';

CREATE INDEX indy ON sro_table_exp (sro_activity1(a));

CREATE OR REPLACE FUNCTION sro_activity1(integer) RETURNS integer
   LANGUAGE sql SECURITY INVOKER AS
'INSERT INTO public.sro_table0 VALUES (current_user); SELECT $1';

CREATE OR REPLACE FUNCTION sro_activity2(integer) RETURNS integer
   LANGUAGE sql SECURITY INVOKER AS
'INSERT INTO public.sro_table1 VALUES (current_user); SELECT $1';

CREATE OR REPLACE FUNCTION sro_trigger() RETURNS trigger
AS $e$ BEGIN
PERFORM public.sro_snfunc(1000); RETURN NEW;
END $e$
LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION sro_activity2(integer) RETURNS integer
   LANGUAGE sql SECURITY INVOKER AS
'INSERT INTO public.sro_table1 VALUES (current_user);
ALTER USER regress_sro_user SUPERUSER;
SELECT $1';

CREATE OR REPLACE FUNCTION sro_trigger() RETURNS trigger
AS $e$
BEGIN
PERFORM public.sro_activity2(1000); RETURN NEW;
END $e$
LANGUAGE plpgsql;

CREATE CONSTRAINT TRIGGER def
    AFTER INSERT ON sro_table0
    INITIALLY DEFERRED FOR EACH ROW
    EXECUTE PROCEDURE sro_trigger();

ANALYZE sro_table_exp;

INSERT INTO sro_table_exp VALUES (1,1), (2,3),(4,5),(6,7),(8,9);
DELETE FROM sro_table_exp;
INSERT INTO sro_table_exp VALUES (1,1);

ALTER TABLE sro_table_exp SET (autovacuum_vacuum_threshold = 1);
ALTER TABLE sro_table_exp SET (autovacuum_analyze_threshold = 1);