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>
