1 -- @tag: delete_cust_vend_tax
2 -- @description: Alte Tabellen löschen
3 -- @depends: delete_customertax_vendortax_partstax
6 CREATE OR REPLACE FUNCTION del_customer() RETURNS "trigger" AS
8 DELETE FROM shipto WHERE trans_id = old.id;
10 END;' LANGUAGE plpgsql;
12 CREATE OR REPLACE FUNCTION del_vendor() RETURNS "trigger" AS
14 DELETE FROM shipto WHERE trans_id = old.id;
16 END;' LANGUAGE plpgsql;