Re: FK triggers misused?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: FK triggers misused?
Дата
Msg-id 26399.1176614941@sss.pgh.pa.us
обсуждение исходный текст
Ответ на FK triggers misused?  (cluster <skrald@amossen.dk>)
Список pgsql-performance
cluster <skrald@amossen.dk> writes:
> It seems that the FK triggers for the table are evaluated even though
> none of the FK columns are altered.

Hm, they're not supposed to be, at least not in reasonably modern
PG releases (and one that breaks out trigger runtime in EXPLAIN ANALYZE
should be modern enough IIRC).  Exactly which PG release are you
running?  Can you provide a self-contained test case?

            regards, tom lane

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

Предыдущее
От: cluster
Дата:
Сообщение: FK triggers misused?
Следующее
От: Andrew - Supernews
Дата:
Сообщение: Re: FK triggers misused?