Alvaro Herrera <alvhe...@alvh.no-ip.org> 于2024年10月22日周二 05:52写道:
> On 2024-Oct-21, Tender Wang wrote: > > > I suspect that we don't need the below if > > statement anymore. > > /* > > * If the referenced side is partitioned (which we know because our > > * parent's constraint points to a different relation than ours) then > > * we must, in addition to the above, create pg_constraint rows that > > * point to each partition, each with its own action triggers. > > */ > > if (parentConForm->conrelid != conform->conrelid) > > { > > ... > > } > > > > The above contidion is always true according to my test. > > I haven't figured out an anti-case. > > You're right, this is useless, we can remove the 'if' line. I kept the > block though, to have a place for all those local variable declarations > (otherwise the code looks messier than it needs to). > Agree. > > I also noticed that addFkRecurseReferenced() is uselessly taking a List > **wqueue argument but doesn't use it, so I removed it (as fallout, other > routines don't need it either, especially DetachPartitionFinalize). I > added some commentary on the creation of dependencies in > addFkConstraint(). > Yeah, I also noticed this before. > > I also include a few other cosmetic changes; just comment layout > changes. > > This time I attach the patch for master only; the others have changed > identically. 14 is unchanged from before. I figured that the conflict > from 14 to 13 was trivial to resolve -- it was just because of DETACH > CONCURRENTLY, so some code moves around, but that's all that happens. > > I don't find any other problems with the newest patch. -- Thanks, Tender Wang