trigger_ar_payment.sql

CREATE OR REPLACE FUNCTION update_ar_payment() RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
    INSERT INTO sync_ar_payment (invoice_id, payment_id) VALUES (NEW.ar_invoice_id, NEW.id);
    RETURN NEW;
END
$$;

CREATE OR REPLACE FUNCTION delete_ar_payment() RETURNS TRIGGER
LANGUAGE plpgsql
AS
$$
BEGIN
    INSERT INTO sync_ar_payment (invoice_id, payment_id) VALUES (OLD.ar_invoice_id, OLD.id);
    RETURN OLD;
END
$$;

CREATE TRIGGER update_ar_payment
    AFTER INSERT OR UPDATE
    ON webr.ar_payment
    FOR EACH ROW EXECUTE PROCEDURE update_ar_payment();

CREATE TRIGGER delete_ar_payment
    AFTER DELETE
    ON webr.ar_payment
    FOR EACH ROW EXECUTE PROCEDURE delete_ar_payment();