CREATE OR REPLACE FUNCTION inject_attachment_insert_failure() RETURNS trigger AS $$ BEGIN RAISE EXCEPTION 'injected attachment insert failure' USING ERRCODE = '57014'; END; $$ LANGUAGE plpgsql; DROP TRIGGER IF EXISTS inject_attachment_insert_failure ON attachments; CREATE TRIGGER inject_attachment_insert_failure BEFORE INSERT ON attachments FOR EACH ROW EXECUTE FUNCTION inject_attachment_insert_failure();