1 -- @tag: record_links_post_delete_triggers2
2 -- @description: PL/PgSQL Syntax Fix
3 -- @depends: record_links_post_delete_triggers
6 CREATE OR REPLACE FUNCTION clean_up_record_links_before_oe_delete() RETURNS trigger AS $$
8 DELETE FROM record_links
9 WHERE (from_table = 'oe' AND from_id = OLD.id)
10 OR (to_table = 'oe' AND to_id = OLD.id);
15 CREATE OR REPLACE FUNCTION clean_up_record_links_before_delivery_orders_delete() RETURNS trigger AS $$
17 DELETE FROM record_links
18 WHERE (from_table = 'delivery_orders' AND from_id = OLD.id)
19 OR (to_table = 'delivery_orders' AND to_id = OLD.id);
24 CREATE OR REPLACE FUNCTION clean_up_record_links_before_ar_delete() RETURNS trigger AS $$
26 DELETE FROM record_links
27 WHERE (from_table = 'ar' AND from_id = OLD.id)
28 OR (to_table = 'ar' AND to_id = OLD.id);
33 CREATE OR REPLACE FUNCTION clean_up_record_links_before_ap_delete() RETURNS trigger AS $$
35 DELETE FROM record_links
36 WHERE (from_table = 'ap' AND from_id = OLD.id)
37 OR (to_table = 'ap' AND to_id = OLD.id);