aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_sales_target_protect_master
Parameters
Name
Type
Mode
Definition
BEGIN IF TG_OP = 'UPDATE' AND NEW.id IS NOT DISTINCT FROM OLD.id THEN RETURN NEW; END IF; IF EXISTS ( SELECT 1 FROM public.sales_target WHERE segment_type = TG_ARGV[0] AND segment_id = OLD.id ) THEN RAISE EXCEPTION 'Cannot delete or change id of %, id %: it is used by a sales target', TG_ARGV[0], OLD.id USING ERRCODE = '23503'; END IF; RETURN CASE WHEN TG_OP = 'DELETE' THEN OLD ELSE NEW END; END