Re: Foreign key validation failure in 18beta1 - Mailing list pgsql-hackers

From Tender Wang
Subject Re: Foreign key validation failure in 18beta1
Date
Msg-id CAHewXNmAYWAPLRdFh9ou4W=P9mUM+XMoTd4Ne1jQaG5OzRAaPA@mail.gmail.com
Whole thread Raw
In response to Foreign key validation failure in 18beta1  (Antonin Houska <ah@cybertec.at>)
Responses Re: Foreign key validation failure in 18beta1
List pgsql-hackers


Antonin Houska <ah@cybertec.at> 于2025年5月28日周三 15:51写道:
I've come across an unexpected ERROR during validation of FK constraint in PG
18beta1. The same works in PG 17:

drop table if exists fk;
drop table if exists pk;
create table pk(i int primary key) partition by range (i);
create table pk_1 partition of pk for values from (0) to (1);
create table pk_2 partition of pk for values from (1) to (2);
insert into pk values (0), (1);
create table fk(i int);
insert into fk values (1);

-- Works if the FK constraint is created as valid.
--alter table fk add foreign key(i) references pk;

-- Fails if the FK constraint is created as NOT VALID and validated
-- afterwards.
alter table fk add foreign key(i) references pk not valid;
alter table fk validate constraint fk_i_fkey;

git bisect shows since below commit, the failure started.

commit b663b9436e7509b5e73c8c372539f067cd6e66c1
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Date:   Thu Jan 23 15:54:38 2025 +0100

    Allow NOT VALID foreign key constraints on partitioned tables 


--
Thanks,
Tender Wang

pgsql-hackers by date:

Previous
From: Tender Wang
Date:
Subject: Re: MERGE issues around inheritance
Next
From: Peter Eisentraut
Date:
Subject: Re: Standardize the definition of the subtype field of AlterDomainStmt