Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key
Date
Msg-id Yi7z7v5vY6ArWBok@paquier.xyz
Whole thread Raw
In response to Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
On Fri, Mar 11, 2022 at 01:29:05PM -0500, Tom Lane wrote:
> Oh, of course:

Thanks for dropping by the thread.  I was planning to bisect that
but with the CF things have gone out of hand.

> the failure only occurs if we think the index is clustered
> or a replica-identity index; else we don't store a request to rebuild it.

Yes, I think that what you did in 369398e to tweak
get_constraint_name() is the right fix, or we'd finish by creating
more index rebuild requests than necessary when going through the
inheritance tree of these tables.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Noah Misch
Date:
Subject: Re: Reconnect a single connection used by multiple threads in embedded SQL in C application causes error.
Next
From: Michael Paquier
Date:
Subject: Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key