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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #15677: Crash while deleting from partitioned table
Дата
Msg-id 20190628215603.GA12247@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #15677: Crash while deleting from partitioned table  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: BUG #15677: Crash while deleting from partitioned table  (Amit Langote <amitlangote09@gmail.com>)
Список 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

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Juan José Santamaría Flecha
Дата:
Сообщение: Re: BUG #15858: could not stat file - over 4GB
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15383: Join Filter cost estimation problem in 10.5