1 -- @tag: delete_cust_vend_tax
2 -- @description: Alte Tabellen löschen
3 -- @depends: delete_customertax_vendortax_partstax
5 CREATE OR REPLACE FUNCTION del_customer() RETURNS "trigger" AS
7 DELETE FROM shipto WHERE trans_id = old.id;
9 END;' LANGUAGE plpgsql;
11 CREATE OR REPLACE FUNCTION del_vendor() RETURNS "trigger" AS
13 DELETE FROM shipto WHERE trans_id = old.id;
15 END;' LANGUAGE plpgsql;