Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self" - Mailing list pgsql-bugs

From Andres Freund
Subject Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
Date
Msg-id 20190724021555.vnytr6ihqeuqjm2p@alap3.anarazel.de
Whole thread Raw
In response to ANALYZE on parent table results in an error "tuple already updated by self"  (Manuel Rigger <rigger.manuel@gmail.com>)
Responses Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"  (Manuel Rigger <rigger.manuel@gmail.com>)
List pgsql-bugs
Hi,

On 2019-07-24 03:19:19 +0200, Manuel Rigger wrote:
> Hi everyone,
> 
> 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.

Yea, that's the bug I was referencing earlier in your other thread:
https://www.postgresql.org/message-id/20190619000837.awy6j7h45ahd4vop%40alap3.anarazel.de

Greetings,

Andres Freund



pgsql-bugs by date:

Previous
From: Manuel Rigger
Date:
Subject: ANALYZE on parent table results in an error "tuple already updated by self"
Next
From: Michael Paquier
Date:
Subject: Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"