From: | shawn everett <everett(at)pgweb(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | deleting from a view |
Date: | 2000-10-17 23:04:10 |
Message-ID: | Pine.LNX.4.21.0010171557090.23851-100000@alder.pgweb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Before I get flamed for not RTFM I do know I can use a rule to do this.
Here's the problem:
I have a view that is made up of two tables.
When I delete from the view I would like the records to be deleted from
both tables that make up my view. What is the best way to accomplish
this?
Should I use a trigger or a rule? If I use a trigger how should it be
written. If I use a rule how do I put two delete statements in it.
I'd like to be able to do something along the lines of:
CREATE RULE view_raw_reman_prod_delete3 AS
ON DELETE TO view_raw_reman_prod
DO INSTEAD
'BEGIN
DELETE FROM reman_costraw1 WHERE prod_date=old.prod_date;
DELETE FROM reman_cost_total_raw1 WHERE prod_date=old.prod_date;
END;';
This doesn't work :)
I've tried splitting things up and using two rules however the second rule
always fails. I suspect that's becuase old.prod_date is set to null.
Any tips or advice would be greatly aprecated.
Shawn
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2000-10-17 23:14:57 | Re: deleting from a view |
Previous Message | Jean-Christophe Boggio | 2000-10-17 22:20:01 | Re: Oracle9iIs it more fluff than stuff? |