Re: Foreign key validation failure in 18beta1
От | Tender Wang |
---|---|
Тема | Re: Foreign key validation failure in 18beta1 |
Дата | |
Msg-id | CAHewXNmAYWAPLRdFh9ou4W=P9mUM+XMoTd4Ne1jQaG5OzRAaPA@mail.gmail.com обсуждение исходный текст |
Ответ на | Foreign key validation failure in 18beta1 (Antonin Houska <ah@cybertec.at>) |
Ответы |
Re: Foreign key validation failure in 18beta1
|
Список | 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.
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 по дате отправления: