Re: Update trigger help - Mailing list pgsql-novice

From A Gilmore
Subject Re: Update trigger help
Date
Msg-id 435D31DA.5070103@shaw.ca
Whole thread Raw
In response to Update trigger help  (A Gilmore <agilmore@shaw.ca>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From:
Date:
Subject: Fwd: Re: PostgreSQL Database Server 8.0 Service Password Problem - WinXP Home
Next
From:
Date:
Subject: Re: PostgreSQL Database Server 8.0 Service Password Problem - WinXP Home