Horton

Re: BUG #17409: Unable to alter data type of clustered column which is referenced by foreign key

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Japin Li <japinli@hotmail.com>, holly.roberts@starlingbank.com, peter@eisentraut.org, pgsql-bugs@lists.postgresql.org
Date: 2022-03-14T08:08:59Z
Lists: pgsql-bugs 
On Mon, Mar 14, 2022 at 04:51:10PM +0900, Michael Paquier wrote:
> 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.

Ditto, 641f3df.
--
Michael

Commits

  1. Restore the previous semantics of get_constraint_index().

  2. Change get_constraint_index() to use pg_constraint.conindid