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
5 CREATE OR REPLACE FUNCTION clean_up_after_customer_vendor_delete() RETURNS trigger AS $$
8 WHERE cp_cv_id = OLD.id;
11 WHERE (trans_id = OLD.id)
18 CREATE TRIGGER after_delete_customer_trigger
19 AFTER DELETE ON customer FOR EACH ROW EXECUTE
20 PROCEDURE clean_up_after_customer_vendor_delete();
22 CREATE TRIGGER after_delete_vendor_trigger
23 AFTER DELETE ON vendor FOR EACH ROW EXECUTE
24 PROCEDURE clean_up_after_customer_vendor_delete();