Re: FK triggers misused?

Список
Период
Сортировка
От Tom Lane
Тема Re: FK triggers misused?
Дата
Msg-id 12251.1176767706@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: FK triggers misused?  (cluster)
Ответы Re: FK triggers misused?  (cluster)
Список pgsql-performance
Дерево обсуждения
FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (Tom Lane, )
 Re: FK triggers misused?  (Andrew - Supernews, )
  Re: FK triggers misused?  (cluster, )
   Re: FK triggers misused?  (Tom Lane, )
   Re: FK triggers misused?  (Tom Lane, )
    Re: FK triggers misused?  (cluster, )
 Re: FK triggers misused?  (cluster, )
  Re: FK triggers misused?  (Stephan Szabo, )
Idly thumbing through the code, I came across something that might
possibly explain your results.  Do the rows being updated contain
NULLs in the foreign-key columns?  I see that ri_KeysEqual() treats
two null values as not equal, which might be overzealous respect for
SQL null semantics in this context.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Fwd: Strangely Variable Query Performance
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Basic Q on superfluous primary keys