Create Postgres trigger to delete `contact_mechanisms_[addresses|phones|emails]` row when related `contact_mechanisms` gets deleted

[lhrnd0]

Resources

• https://www.postgresql.org/docs/14/trigger-definition.html
• https://www.postgresql.org/docs/14/sql-createtrigger.html
• https://www.postgresql.org/docs/14/plpgsql.html

Code example

CREATE FUNCTION delete_related_contact_mechanisms() 
RETURNS TRIGGER LANGUAGE PLPGSQL AS 
$$ 
BEGIN -- trigger logic
  IF OLD.contact_mechanism_address_id THEN
  END IF;
END;
$$ 

CREATE TRIGGER delete_related_contact_mechanisms
AFTER DELETE ON contact_mechanisms 
FOR EACH ROW 
EXECUTE PROCEDURE delete_related_contact_mechanisms