aboutsummaryrefslogtreecommitdiffstats
path: root/notes/projects/radius/sql/ippool-schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'notes/projects/radius/sql/ippool-schema.sql')
-rw-r--r--notes/projects/radius/sql/ippool-schema.sql7
1 files 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
246 246
247 -- verifies ip is not assigned to a RADIUS accounting session 247 -- verifies ip is not assigned to a RADIUS accounting session
248 IF ( OLD.nasId IS NOT NULL ) THEN 248 IF ( OLD.nasId IS NOT NULL ) THEN
249 RAISE EXCEPTION 'IP address is still assigned to NAS session'; 249 RETURN NULL;
250 END IF; 250 END IF;
251 251
252 RETURN NEW; 252 RETURN OLD;
253END; 253END;
254$$; 254$$;
255 255
@@ -285,8 +285,7 @@ CREATE OR REPLACE FUNCTION ip_trigger_truncate
285 AS $$ 285 AS $$
286DECLARE 286DECLARE
287BEGIN 287BEGIN
288 RAISE EXCEPTION 'DO NOT TRUNCATE IP TABLE'; 288 RETURN NULL;
289 RETURN NEW;
290END; 289END;
291$$; 290$$;
292 291