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

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

Seems solved in 11.1

On 11/5/18 9:16 PM, Tom Lane wrote:
> "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

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Munro 2018-11-09 19:28:25 Re: BUG #15495: Ldap authentication not working with multiple server in Postgresql 11
Previous Message Alvaro Herrera 2018-11-09 17:07:12 Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation