Re: BUG #15677: Crash while deleting from partitioned table - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #15677: Crash while deleting from partitioned table
Date
Msg-id 20190628215603.GA12247@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #15677: Crash while deleting from partitioned table  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: BUG #15677: Crash while deleting from partitioned table
List 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                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-bugs by date:

Previous
From: Juan José Santamaría Flecha
Date:
Subject: Re: BUG #15858: could not stat file - over 4GB
Next
From: Tom Lane
Date:
Subject: Re: BUG #15383: Join Filter cost estimation problem in 10.5