1 -- @tag: record_links_post_delete_triggers2
2 -- @description: PL/PgSQL Syntax Fix
3 -- @depends: record_links_post_delete_triggers
5 CREATE OR REPLACE FUNCTION clean_up_record_links_before_oe_delete() RETURNS trigger AS $$
7 DELETE FROM record_links
8 WHERE (from_table = 'oe' AND from_id = OLD.id)
9 OR (to_table = 'oe' AND to_id = OLD.id);
14 CREATE OR REPLACE FUNCTION clean_up_record_links_before_delivery_orders_delete() RETURNS trigger AS $$
16 DELETE FROM record_links
17 WHERE (from_table = 'delivery_orders' AND from_id = OLD.id)
18 OR (to_table = 'delivery_orders' AND to_id = OLD.id);
23 CREATE OR REPLACE FUNCTION clean_up_record_links_before_ar_delete() RETURNS trigger AS $$
25 DELETE FROM record_links
26 WHERE (from_table = 'ar' AND from_id = OLD.id)
27 OR (to_table = 'ar' AND to_id = OLD.id);
32 CREATE OR REPLACE FUNCTION clean_up_record_links_before_ap_delete() RETURNS trigger AS $$
34 DELETE FROM record_links
35 WHERE (from_table = 'ap' AND from_id = OLD.id)
36 OR (to_table = 'ap' AND to_id = OLD.id);