Re: Delete rule chain stops unexpectedly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Delete rule chain stops unexpectedly
Дата
Msg-id 21436.1129905772@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Delete rule chain stops unexpectedly  (Wiebe Cazemier <halfgaar@gmail.com>)
Ответы Re: Delete rule chain stops unexpectedly  (Wiebe Cazemier <halfgaar@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Mario Splivalo
Дата:
Сообщение: Re: Postgres 7.4.9 slow!
Следующее
От: Wiebe Cazemier
Дата:
Сообщение: Re: Delete rule chain stops unexpectedly