ONLY in queries by RI triggers

Поиск
Список
Период
Сортировка
От Vladimir Borodin
Тема ONLY in queries by RI triggers
Дата
Msg-id D7D179A7-A943-4BCD-AC5C-9766184B4ED4@simply.name
обсуждение исходный текст
Ответы Re: ONLY in queries by RI triggers  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi all.<div class=""><br class="" /></div><div class="">A long time ago in 04b31609b63ce77fb9273193f07cf21b2a7176af
ONLYkeyword was added to all queries in src/backend/utils/adt/ri_triggers.c. Since that time foreign keys do not work
withinheritance trees and it is mentioned in the documentation for all versions since at least 7.3. </div><div
class=""><brclass="" /></div><div class="">I wonder what are the pitfalls of removing ONLY keyword from those queries?
Ihave made such change, it passes all tests and foreign keys for partitioned tables do work, but I suppose that there
arelots of places where it could break something.</div><div class=""><br class="" /></div><div class="">Thanks in
advance.<brclass="" /><div apple-content-edited="true" class=""><div class="" style="color: rgb(0, 0, 0); font-family:
Helvetica;font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal;
line-height:normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal;
widows:auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><br class="Apple-interchange-newline" />--</div><div
class=""style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal;
font-weight:normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px;
text-transform:none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">May the
forcebe with you…</div><div class="" style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style:
normal;font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto;
text-align:start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width:0px;"><a class="" href="https://simply.name">https://simply.name</a></div></div><br class=""
/></div>

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Buildfarm client version 4.15 released
Следующее
От: Andres Freund
Дата:
Сообщение: Re: ONLY in queries by RI triggers