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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: ANALYZE on parent table results in an error "tuple already updated by self"
Date: 2019-07-24 02:32:16
Message-ID: 20190724023216.GD14257@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dilip Kumar 2019-07-24 05:35:03 Re: partition table slow planning
Previous Message Andres Freund 2019-07-24 02:15:55 Re: ANALYZE on parent table results in an error "tuple already updated by self"