Re: Update trigger help

A Gilmore wrote:
> Hello,
>
> I have a main table (t1), with several other tables referencing the ID
> of t1. When I update a row on t1 Id like to remove any rows that
> reference it in the other tables. The typical way of doing this Id
> assume is using ON UPDATE trigger, which Ive written below. Is this all
> correct? In the past Ive just been using plpgsql for returning rows in
> which a VIEW wasn't sufficient, so Id like to just make sure Im doing
> this correctly.

Er, rather here is the function had I proof read my email :

CREATE OR REPLACE FUNCTION t1_onUpdate() RETURNS TRIGGER AS '
DECLARE
id INT;
BEGIN
id := NEW.id;
DELETE FROM t2 WHERE t1_id = id;
DELETE FROM t3 WHERE t1_id = id;
DELETE FROM t4 WHERE t1_id = id;
DELETE FROM t5 WHERE t1_id = id;
DELETE FROM t6 WHERE t1_id = id;
RETURN NEW;
END;
'LANGUAGE plpgsql;

CREATE TRIGGER t1_onUpdate BEFORE UPDATE ON t1
FOR EACH ROW EXECUTE PROCEDURE t1_onUpdate();

Thank you,
- A Gilmore