aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_trg_masterfile_before_delete
Parameters
Name
Type
Mode
Definition
DECLARE target_id INT; -- target_connect_rooms INT[]; v_table_name text; v_table_name_upper text; begin -- === create by T.Supol 2025-06-24 v_table_name := TG_TABLE_NAME; v_table_name_upper := upper(v_table_name); if v_table_name_upper = 'TITLE' then if fn_sys_param('DEFAULT','TITLE',null::int4) = old.id then raise exception 'can not delete [%]', v_table_name ; elsif fn_sys_param('DEFAULT','TITLE_MALE',null::int4) = old.id then raise exception 'can not delete [%]', v_table_name; elsif fn_sys_param('DEFAULT','TITLE_FEMALE',null::int4) = old.id then raise exception 'can not delete [%]', v_table_name; else return old; end if; end if; if fn_sys_param('DEFAULT',v_table_name_upper,null::int4) = old.id then raise exception 'can not delete [%]', v_table_name ; else return old; end if; END;