Postgres Pro
Downloads
Home   >   mailing lists

ANALYZE on parent table results in an error "tuple already updated by self" - Mailing list pgsql-bugs

From Manuel Rigger
Subject ANALYZE on parent table results in an error "tuple already updated by self"
Date
Msg-id CA+u7OA69sgyCE0VhEpgZLBkR4X0frA2=ar8brntoH1vcvi-+WA@mail.gmail.com
Whole thread Raw
Responses Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"  (Michael Paquier <michael@paquier.xyz>)
Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Jatinder Sandhu
Date:
Subject: partition table slow planning
Next
From: Andres Freund
Date:
Subject: Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"