Horton

Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns

Amit Langote <amitlangote09@gmail.com>

View thread View on postgr.es
From: Amit Langote <amitlangote09@gmail.com>
To: Junwang Zhao <zhjwpku@gmail.com>
Cc: Matheus Alcantara <matheusssilv97@gmail.com>, Fredrik Widlert <fredrik.widlert@digpro.se>, pgsql-bugs@lists.postgresql.org
Date: 2026-04-10T06:32:31Z
Lists: pgsql-bugs 
On Fri, Apr 10, 2026 at 1:42 PM Amit Langote <amitlangote09@gmail.com> wrote:
> Thanks Junwang for checking.  I've just pushed this: 980c1a85d819.

Pushed a follow up commit to add an Assert making the single-column
invariant explicit in ri_FastPathFlushArray(), per Junwang's
suggestion off-list.

-- 
Thanks, Amit Langote

Commits

  1. Add test case for same-type reordered FK columns

  2. Assert index_attnos[0] == 1 in ri_FastPathFlushArray()

  3. Fix FK fast-path scan key ordering for mismatched column order

  4. Add fast path for foreign key constraint checks