Re: Delete rule chain stops unexpectedly - Mailing list pgsql-sql

From Tom Lane
Subject Re: Delete rule chain stops unexpectedly
Date
Msg-id 21436.1129905772@sss.pgh.pa.us
Whole thread Raw
In response to Delete rule chain stops unexpectedly  (Wiebe Cazemier <halfgaar@gmail.com>)
Responses Re: Delete rule chain stops unexpectedly  (Wiebe Cazemier <halfgaar@gmail.com>)
List pgsql-sql
Wiebe Cazemier <halfgaar@gmail.com> writes:
> which I manipulate with the view "rating_params". The delete rules on this view 
> act very strangely.

The rule that actually deletes the rows from the underlying has to fire
last, since the rows are gone from the view (and hence from OLD) the
moment you delete them.

In practice, you'd be way better off using an ON DELETE trigger for
these tasks.
        regards, tom lane


pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Postgres 7.4.9 slow!
Next
From: Wiebe Cazemier
Date:
Subject: Re: Delete rule chain stops unexpectedly