egdb3_12_9
.action
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
copy_transit_is_unique()
Parameters
Name
Type
Mode
IN
Definition
BEGIN PERFORM * FROM action.transit_copy WHERE target_copy = NEW.target_copy AND dest_recv_time IS NULL AND cancel_time IS NULL; IF FOUND THEN RAISE EXCEPTION 'Copy id=% is already in transit', NEW.target_copy; END IF; RETURN NULL; END;