On Mon, Oct 18, 2021 at 12:24 PM Amit Kapila <amit.kapil...@gmail.com> wrote: > > On Wed, Oct 13, 2021 at 9:11 AM Amit Langote <amitlangot...@gmail.com> wrote: > > Anyway, I'll think a bit more about the possible hazards of not doing > > the locking and will reply again if there's indeed a problem(s) that > > needs to be fixed. > > > > I think you can try to reproduce the problem via the debugger. You can > stop before calling GetPubPartitionOptionRelations in > publication_add_relation() in session-1 and then from another session > (say session-2) try to delete one of the partition table (without > replica identity). Then stop in session-2 somewhere after acquiring > lock to the corresponding partition relation. Now, continue in > session-1 and invalidate the rels and let it complete the command. I > think session-2 will complete the update without processing the > invalidations. >
In the last sentence, it should be delete rather than update. -- With Regards, Amit Kapila.
