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

From: Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: ANALYZE on parent table results in an error "tuple already updated by self"
Date: 2019-07-24 01:19:19
Message-ID: CA+u7OA69sgyCE0VhEpgZLBkR4X0frA2=ar8brntoH1vcvi-+WA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-07-24 02:15:55 Re: ANALYZE on parent table results in an error "tuple already updated by self"
Previous Message Jatinder Sandhu 2019-07-23 22:48:43 partition table slow planning