Re: relcache not invalidated when ADD PRIMARY KEY USING INDEX - Mailing list pgsql-hackers

From Tom Lane
Subject Re: relcache not invalidated when ADD PRIMARY KEY USING INDEX
Date
Msg-id 1476151.1642876684@sss.pgh.pa.us
Whole thread Raw
In response to Re: relcache not invalidated when ADD PRIMARY KEY USING INDEX  ("Euler Taveira" <euler@eulerto.com>)
List pgsql-hackers
"Euler Taveira" <euler@eulerto.com> writes:
> On Mon, Dec 20, 2021, at 3:45 AM, houzj.fnst@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



pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: pg_upgrade/test.sh and v9.5
Next
From: Noah Misch
Date:
Subject: Re: XLogReadRecord() error in XlogReadTwoPhaseData()