Re: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server

On 2018-Nov-02, Alvaro Herrera wrote:

> On 2018-Nov-01, PG Bug reporting form wrote:
>
> > is it normal that server break (segmentation fault, recovery mode and
> > restart !) if i
>
> Of course not. Looking into it now.

I cannot reproduce it,

create table part (a int primary key, b int) partition by range (a);
create table part1 partition of part for values from (0) to (1000);
alter table part1 add foreign key (b) references part1 on update cascade on delete restrict;
insert into part1 values (1, null);
insert into part1 values (10, 1);
delete from part1 where a = 1;

This works fine (i.e. throws error that referencing row exists).

There must be some other element to your schema that I'm missing. What
is it? Also, if you got a core file, can you obtain a backtrace from
it?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services