Thread: ANALYZE on parent table results in an error "tuple already updated by self"
ANALYZE on parent table results in an error "tuple already updated by self"
From
Manuel Rigger
Date:
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. Best, Manuel
Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
From
Andres Freund
Date:
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
Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
From
Michael Paquier
Date:
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
Attachment
Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
From
Manuel Rigger
Date:
Thanks, and sorry for having overlooked this bug report! Best, Manuel On Wed, Jul 24, 2019 at 8:00 AM Andres Freund <andres@anarazel.de> wrote: > > 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