diff options
Diffstat (limited to 'notes/projects/radius/sql/ippool-schema.sql')
| -rw-r--r-- | notes/projects/radius/sql/ippool-schema.sql | 7 |
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; |
| 253 | END; | 253 | END; |
| 254 | $$; | 254 | $$; |
| 255 | 255 | ||
| @@ -285,8 +285,7 @@ CREATE OR REPLACE FUNCTION ip_trigger_truncate | |||
| 285 | AS $$ | 285 | AS $$ |
| 286 | DECLARE | 286 | DECLARE |
| 287 | BEGIN | 287 | BEGIN |
| 288 | RAISE EXCEPTION 'DO NOT TRUNCATE IP TABLE'; | 288 | RETURN NULL; |
| 289 | RETURN NEW; | ||
| 290 | END; | 289 | END; |
| 291 | $$; | 290 | $$; |
| 292 | 291 | ||
