19 lines
500 B
PL/PgSQL
19 lines
500 B
PL/PgSQL
|
-----------------------------------------
|
||
|
|
-- 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();
|