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

Manuel Rigger <[email protected]> Wed, 24 Jul 2019 09:17:36 +0200

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<CA+u7OA4kJ=CnPaanK94jN1KqRRHCsHWPcPdKT9LUm44=R5P5kg@mail.gmail.com>

Thanks, and sorry for having overlooked this bug report!

Best,
Manuel

On Wed, Jul 24, 2019 at 8:00 AM Andres Freund <[email protected]> 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