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

Поиск
Список
Период
Сортировка
От Doug Safreno
Тема Re: Bug: Deferred FKey Check Happening on Double Update, Not Single
Дата
Msg-id CAA=+orsauoKK_qit6kpe9TUYhUATkLQWFUPp2VOhEdN23p3+3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug: Deferred FKey Check Happening on Double Update, Not Single  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-bugs
Дерево обсуждения
Gotcha, thanks for explanation.

Best,
Doug


On Fri, Feb 15, 2019 at 3:15 PM Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>> "Doug" == Doug Safreno <doug@avinetworks.com> writes:

 Doug> Hey Sergei,

 Doug> Neither transaction touches FK fields - so shouldn't they both
 Doug> skip FK trigger check?

The optimization that lets the check be skipped only applies on the
_first_ modification of the row within the transaction. On the second or
subsequent modifications, the code can't easily tell whether the row was
inserted in the current transaction (in which case the optimization must
be skipped) or just modified, so it assumes the worst.

--
Andrew (irc:RhodiumToad)

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Bug: Deferred FKey Check Happening on Double Update, Not Single
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #15631: Generated as identity field in a temporary tablewith on commit drop corrupts system catalogs