egdb3_11_7
.asset
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
check_delete_copy_location(acpl_id integer)
Parameters
Name
Type
Mode
acpl_id
integer
IN
Definition
BEGIN PERFORM TRUE FROM asset.copy WHERE location = acpl_id AND NOT deleted LIMIT 1; IF FOUND THEN RAISE EXCEPTION 'Copy location % contains active copies and cannot be deleted', acpl_id; END IF; IF acpl_id = 1 THEN RAISE EXCEPTION 'Copy location 1 cannot be deleted'; END IF; END;