ANALYZE on parent table results in an error "tuple already updated by self"

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:
/messages/by-id/20190619000837.awy6j7h45ahd4vop@alap3.anarazel.de

Greetings,

Andres Freund

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:
/messages/by-id/20190618231233.GA27470@telsasoft.com
--
Michael

Thanks, and sorry for having overlooked this bug report!

Best,
Manuel