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  (Doug Safreno <doug@avinetworks.com>)
Список 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 по дате отправления:

Предыдущее
От: John Klann
Дата:
Сообщение: Re: BUG #15636: PostgreSQL 11.1 pg_basebackup backup to a CIFSdestination throws fsync error at end of backup
Следующее
От: Marc Schablewski
Дата:
Сообщение: Re: BUG #15637: Problem insert data 【Japanese】