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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ing(dot) Gianluca Alberici" <alberici(at)abinetworks(dot)biz>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server
Date: 2018-11-05 20:16:17
Message-ID: 14487.1541448977@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ing. Gianluca Alberici" <alberici(at)abinetworks(dot)biz> writes:
> Actually it is a strange behavior, look at this:

> abi2=> begin;
> BEGIN
> abi2=>*delete from _abi_main_pof_t where poftid=1843635; server closed the
> connection unexpectedly     This probably means the server terminated
> abnormally     before or while processing the request. The connection to
> the server was lost. Attempting reset: Failed. !> \q*

Is it possible that you've done ALTER TABLE ADD COLUMN on _abi_main_pof_t
or any other table touched by this query? If so, I bet this is explained
by that expand_tuple bug.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2018-11-05 22:25:09 Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation
Previous Message Alvaro Herrera 2018-11-05 19:23:05 Re: BUG #15437: Segfault during insert into declarative partitioned table with a trigger creating partition