Re: Bug: Deferred FKey Check Happening on Double Update, Not Single

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: Bug: Deferred FKey Check Happening on Double Update, Not Single
Дата
Msg-id 2447821550216518@myt6-add70abb4f02.qloud-c.yandex.net
обсуждение исходный текст
Ответ на Bug: Deferred FKey Check Happening on Double Update, Not Single  (Doug Safreno <doug@avinetworks.com>)
Ответы Re: Bug: Deferred FKey Check Happening on Double Update, Not Single
Список pgsql-bugs
Дерево обсуждения 
Hi

> Which one is expected?

Both are expected. This is foreign key check optimisation: we can safely skip FK trigger check if row was inserted not
inthis transaction and update does not touch FK fields:
https://github.com/postgres/postgres/blob/REL_11_STABLE/src/backend/utils/adt/ri_triggers.c#L1769

> And is this really a bug?
 
so no, this is not bug.

regards, Sergei

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