DROP TABLE IF EXISTS test;
CREATE TEMP TABLE test(
	id bigserial NOT NULL PRIMARY KEY,
	a integer,
	b integer
);

CREATE OR REPLACE FUNCTION test_bi_trg() RETURNS TRIGGER AS $BODY$
DECLARE
	r	RECORD;
BEGIN
	RAISE NOTICE 'begin of test_bi_trg(). New rec: %, %, %', NEW.id, NEW.a, NEW.b;
	FOR r IN SELECT * FROM test LOOP
		RAISE NOTICE 'reading test: %, %, %', r.id, r.a, r.b;
	END LOOP;
	RAISE NOTICE 'end of procedure. RETURNING NEW.';
	RETURN NEW;
END;
$BODY$ LANGUAGE 'plpgsql';

CREATE OR REPLACE FUNCTION test_ai_trg() RETURNS TRIGGER AS $BODY$
DECLARE
	r	RECORD;
BEGIN
	RAISE NOTICE 'begin of test_ai_trg(). New rec: %, %, %', NEW.id, NEW.a, NEW.b;
	FOR r IN SELECT * FROM test LOOP
		RAISE NOTICE 'reading test: %, %, %', r.id, r.a, r.b;
	END LOOP;
	RAISE NOTICE 'end of procedure.';
	RETURN NEW;
END;
$BODY$ LANGUAGE 'plpgsql';

INSERT INTO test VALUES(DEFAULT,  1 ,  2 );

CREATE TRIGGER trg_test_bi_1 BEFORE INSERT ON test FOR EACH ROW EXECUTE PROCEDURE test_bi_trg();
CREATE TRIGGER trg_test_ai_1 AFTER INSERT ON test FOR EACH ROW EXECUTE PROCEDURE test_ai_trg();

INSERT INTO test VALUES(DEFAULT,  3 ,  4 );

NOTICE:  CREATE TABLE will create implicit sequence "test_id_seq" for serial column "test.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"
NOTICE:  begin of test_bi_trg(). New rec:  2 ,  3 ,  4 
NOTICE:  reading test:  1 ,  1 ,  2 
NOTICE:  end of procedure. RETURNING NEW.
NOTICE:  begin of test_ai_trg(). New rec:  2 ,  3 ,  4 
NOTICE:  reading test:  1 ,  1 ,  2 
NOTICE:  reading test:  2 ,  3 ,  4 
NOTICE:  end of procedure.

DROP TABLE test;
CREATE TEMP TABLE test(
	id bigserial NOT NULL PRIMARY KEY,
	a integer,
	b integer
);

CREATE OR REPLACE FUNCTION test_bi_trg() RETURNS TRIGGER AS $BODY$
DECLARE
	r	RECORD;
BEGIN
	RAISE NOTICE 'begin of test_bi_trg(). New rec: %, %, %', NEW.id, NEW.a, NEW.b;
	FOR r IN SELECT * FROM test LOOP
		RAISE NOTICE 'reading test: %, %, %', r.id, r.a, r.b;
	END LOOP;
	IF NEW.a <>  10  THEN
		RAISE NOTICE 'Begin Insert new vaules.';
		INSERT INTO test VALUES (DEFAULT,  10 ,  11 );
		RAISE NOTICE 'Insert new vaules. Rereading';
		FOR r IN SELECT * FROM test LOOP
			RAISE NOTICE 'reading test: %, %, %', r.id, r.a, r.b;
		END LOOP;
	END IF;
	RAISE NOTICE 'end of procedure. RETURNING NEW.';
	RETURN NEW;
END;
$BODY$ LANGUAGE 'plpgsql';

CREATE OR REPLACE FUNCTION test_ai_trg() RETURNS TRIGGER AS $BODY$
DECLARE
	r	RECORD;
BEGIN
	RAISE NOTICE 'begin of test_ai_trg(). New rec: %, %, %', NEW.id, NEW.a, NEW.b;
	FOR r IN SELECT * FROM test LOOP
		RAISE NOTICE 'reading test: %, %, %', r.id, r.a, r.b;
	END LOOP;
	RAISE NOTICE 'end of procedure.';
	RETURN NEW;
END;
$BODY$ LANGUAGE 'plpgsql';

INSERT INTO test VALUES(DEFAULT,  1 ,  2 );

CREATE TRIGGER trg_test_bi_1 BEFORE INSERT ON test FOR EACH ROW EXECUTE PROCEDURE test_bi_trg();
CREATE TRIGGER trg_test_ai_1 AFTER INSERT ON test FOR EACH ROW EXECUTE PROCEDURE test_ai_trg();

INSERT INTO test VALUES(DEFAULT,  3 ,  4 );

NOTICE:  CREATE TABLE will create implicit sequence "test_id_seq" for serial column "test.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "test_pkey" for table "test"
NOTICE:  begin of test_bi_trg(). New rec:  2 ,  3 ,  4 
NOTICE:  reading test:  1 ,  1 ,  2 
NOTICE:  Begin Insert new vaules.
NOTICE:  begin of test_bi_trg(). New rec:  3 ,  10 ,  11 
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  reading test:  1 ,  1 ,  2 
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  end of procedure. RETURNING NEW.
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  begin of test_ai_trg(). New rec:  3 ,  10 ,  11 
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  reading test:  1 ,  1 ,  2 
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  reading test:  3 ,  10 ,  11 
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  end of procedure.
КОНТЕКСТ:  SQL statement "INSERT INTO test VALUES (DEFAULT, 10, 11)"
PL/pgSQL function "test_bi_trg" line  10  at SQL statement
NOTICE:  Insert new vaules. Rereading
NOTICE:  reading test:  1 ,  1 ,  2 
NOTICE:  reading test:  3 ,  10 ,  11 
NOTICE:  end of procedure. RETURNING NEW.
NOTICE:  begin of test_ai_trg(). New rec:  2 ,  3 ,  4 
NOTICE:  reading test:  1 ,  1 ,  2 
NOTICE:  reading test:  3 ,  10 ,  11 
NOTICE:  reading test:  2 ,  3 ,  4 
NOTICE:  end of procedure.