deleting from a view

Поиск
Список
Период
Сортировка
От shawn everett
Тема deleting from a view
Дата
Msg-id Pine.LNX.4.21.0010171557090.23851-100000@alder.pgweb.com
обсуждение исходный текст
Ответы Re: deleting from a view  (Alfred Perlstein <bright@wintelcom.net>)
Re: deleting from a view  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: deleting from a view  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Jean-Christophe Boggio
Дата:
Сообщение: Re: Oracle9iIs it more fluff than stuff?
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: deleting from a view