From 70548a5aed78a692cb6987c5b34ea10bd4ae92e9 Mon Sep 17 00:00:00 2001 From: "David M. Syzdek" Date: Tue, 14 May 2019 15:26:13 -0800 Subject: Fixing triggers --- notes/projects/radius/sql/ippool-schema.sql | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql index fcf74ea..3730051 100644 --- a/notes/projects/radius/sql/ippool-schema.sql +++ b/notes/projects/radius/sql/ippool-schema.sql @@ -246,10 +246,10 @@ BEGIN -- verifies ip is not assigned to a RADIUS accounting session IF ( OLD.nasId IS NOT NULL ) THEN - RAISE EXCEPTION 'IP address is still assigned to NAS session'; + RETURN NULL; END IF; - RETURN NEW; + RETURN OLD; END; $$; @@ -285,8 +285,7 @@ CREATE OR REPLACE FUNCTION ip_trigger_truncate AS $$ DECLARE BEGIN - RAISE EXCEPTION 'DO NOT TRUNCATE IP TABLE'; - RETURN NEW; + RETURN NULL; END; $$; -- cgit v1.2.3