Postgres Pro
Downloads
Home   >   mailing lists

Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server
Date
Msg-id 14487.1541448977@sss.pgh.pa.us
Whole thread Raw
In response to Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED)break the server  ("Ing. Gianluca Alberici" <alberici@abinetworks.biz>)
Responses Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED)break the server
Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED)break the server
Re: Ris: BUG #15482: (SOLVED ?) Foreign keys to a partition (NOT APARTITIONED) break the server
List pgsql-bugs
Tree view 
"Ing. Gianluca Alberici" <alberici@abinetworks.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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15437: Segfault during insert into declarative partitionedtable with a trigger creating partition