CREATE OR REPLACE FUNCTION raise_exp() RETURNS void AS $$ DECLARE BEGIN INSERT INTO t1 VALUES(1,'exp_foo'),(2,'exp_bar'),(3,'exp_hoge'); RAISE EXCEPTION 'EXCEPTION RAISE MESSAGE'; END $$ LANGUAGE plpgsql ;