Re: BUG #15677: Crash while deleting from partitioned table

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc: infernorb(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org>
Subject: Re: BUG #15677: Crash while deleting from partitioned table
Date: 2019-06-28 21:56:03
Message-ID: 20190628215603.GA12247@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

On 2019-Mar-11, Amit Langote wrote:

> To reproduce, use these steps (needs 2 sessions to invoke EvalPlanQual at
> all):
> Setup:
> create table p (a int) partition by list (a);
> create table p1 partition of p for values in (1);
> insert into p values (1);
> Session 1:
> begin;
> update p set a = a;
> Session 2:
> with u as (update p set a = a returning p.*) update p set a = u.a from u;
> <blocks>

Hmmm ... I rewrote to this isolationtester spec and doesn't reproduce a
problem in master. I am probably missing something ...

Álvaro Herrera
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
partition-eval-plan-qual.spec text/plain 395 bytes

In response to


Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-06-28 22:05:57 Re: BUG #15383: Join Filter cost estimation problem in 10.5
Previous Message Juan José Santamaría Flecha 2019-06-28 21:34:38 Re: BUG #15858: could not stat file - over 4GB