public inbox for [email protected]
help / color / mirror / Atom feedFrom: Fredrik Widlert <[email protected]>
To: [email protected]
Subject: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns
Date: Thu, 9 Apr 2026 17:27:19 +0200
Message-ID: <CADfhSr-pCkbDxmiOVYSAGE5QGjsQ48KKH_W424SPk+pwzKZFaQ@mail.gmail.com> (raw)
Hello,
I believe I may have found a regression in PostgreSQL 19devel, downloaded
on 2026-04-09
from https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.gz.
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 19devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu
13.2.0-23ubuntu4) 13.2.0, 64-bit
With the reproducer below, PostgreSQL 18 reports a normal foreign-key
violation
at INSERT time, but PostgreSQL 19devel instead throws an internal-looking
error:
ERROR: operator 98 is not a member of opfamily 1976
-- reproducer:
drop table if exists parent, child;
create table parent (
app_id varchar(256) not null,
report_id smallint not null,
otype integer not null,
subtype integer not null,
ctype integer not null,
column_name varchar(30) not null,
primary key (app_id, report_id, otype, subtype, ctype, column_name)
);
create table child (
app_id varchar(256) not null,
report_id smallint not null,
otype integer not null,
subtype integer not null,
column_name varchar(30) not null,
ctype integer,
-- intentionally swapped: column_name, ctype
constraint child_fk
foreign key (app_id, report_id, otype, subtype, column_name, ctype)
references parent (app_id, report_id, otype, subtype, column_name,
ctype)
);
-- trigger the problem
insert into child (app_id, report_id, otype, subtype, column_name, ctype)
values ('DEFAULT_APP', 0, -1, -1, 'ID', -1);
/Fredrik Widlert
[email protected]
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: BUG: PostgreSQL 19devel throws internal opfamily error for FK with reordered referenced columns
In-Reply-To: <CADfhSr-pCkbDxmiOVYSAGE5QGjsQ48KKH_W424SPk+pwzKZFaQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox