| 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 |
| Thread: | |
| 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 https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| partition-eval-plan-qual.spec | text/plain | 395 bytes |
| 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 |