Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
Дата
Msg-id 20190724023216.GD14257@paquier.xyz
обсуждение исходный текст
Ответ на ANALYZE on parent table results in an error "tuple already updated by self"  (Manuel Rigger <rigger.manuel@gmail.com>)
Список pgsql-bugs
Hi Manuel,

On Wed, Jul 24, 2019 at 03:19:19AM +0200, Manuel Rigger wrote:
> In the example below, ANALYZE unexpectedly results in an error.
>
> CREATE TABLE t0(c0 boolean , c1 integer);
> CREATE TABLE t1(c0 boolean, c1 integer) INHERITS(t0);
> INSERT INTO t0(c1) VALUES (0);
> CREATE STATISTICS s0 ON c0, c1 FROM t0;
> ANALYZE t0; -- unexpected: ERROR:  tuple already updated by self
>
> I found this on the latest trunk version.

This issue was introduced by v11 and has been already reported here:
https://www.postgresql.org/message-id/20190618231233.GA27470@telsasoft.com
--
Michael

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: partition table slow planning