"Euler Taveira" <eu...@eulerto.com> writes: > On Mon, Dec 20, 2021, at 3:45 AM, houzj.f...@fujitsu.com wrote: >> When reviewing some replica identity related patches, I found that when >> adding >> primary key using an existing unique index on not null columns, the >> target table's relcache won't be invalidated.
> Good catch. Indeed. > It seems you can simplify your checking indexForm->indisprimary directly, no? The logic seems fine to me --- it avoids an unnecessary cache flush if the index was already the pkey. (Whether we actually reach this code in such a case, I dunno, but it's not costing much to be smart if we are.) > Why did you add new tests for test_decoding? I think the TAP tests alone are > fine. BTW, this test is similar to publisher3/subscriber3. Isn't it better to > use the same pub/sub to reduce the test execution time? I agree, the proposed test cases are expensive overkill. The repro shown in the original message is sufficient and much cheaper. Moreover, we already have some test cases very much like that in regress/sql/publication.sql, so that's where I put it. Pushed with some minor cosmetic adjustments. regards, tom lane