1 -- @tag: cleanup_after_customer_vendor_deletion
2 -- @description: Nach Löschen von Kunden/Lieferanten via Trigger auch Ansprechpersonen/Lieferadressen löschen
3 -- @depends: release_3_0_0
4 CREATE OR REPLACE FUNCTION clean_up_after_customer_vendor_delete() RETURNS trigger AS $$
7 WHERE cp_cv_id = OLD.id;
10 WHERE (trans_id = OLD.id)
17 CREATE TRIGGER after_delete_customer_trigger
18 AFTER DELETE ON customer FOR EACH ROW EXECUTE
19 PROCEDURE clean_up_after_customer_vendor_delete();
21 CREATE TRIGGER after_delete_vendor_trigger
22 AFTER DELETE ON vendor FOR EACH ROW EXECUTE
23 PROCEDURE clean_up_after_customer_vendor_delete();