CREATE TABLE t1(f1 INT,f2 INT,f3 INT);
CREATE TABLE t2(f1 INT,f2 INT,f3 INT);

CREATE OR REPLACE TRIGGER tr
AFTER INSERT ON t2
FOR EACH ROW
BEGIN
  INSERT INTO t1(f1,f2,f3) VALUES(5,5,5);
END;

CREATE OR REPLACE FUNCTION p()
RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
INSERT INTO t1(f1,f2,f3) VALUES(7,7,7);
RETURN NEW;
END;
$$

CREATE TRIGGER tr
AFTER INSERT ON t2
FOR EACH ROW
EXECUTE PROCEDURE p();

INSERT INTO t2(f1,f2,f3) VALUES (11,11,11);