tube/block-boomprobe.sql

-----------------------------------------
-- Block the boom protocol probe spam ---
-----------------------------------------

CREATE OR REPLACE FUNCTION block_boomprotocolprobe()
RETURNS trigger AS
$$
BEGIN
    IF NEW."registrationReason" = 'Automated protocol deliverability probe' THEN
        RETURN NULL;
    END IF;
    RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER trg_block_boomprotocolprobe
BEFORE INSERT ON "userRegistration"
FOR EACH ROW
EXECUTE FUNCTION block_boomprotocolprobe();