Re: CREATE STATISTICS + Table Inheritance = ERROR: tuple already updated by self

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: David Marcin <david(dot)marcin(at)coinbase(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: CREATE STATISTICS + Table Inheritance = ERROR: tuple already updated by self
Date: 2019-06-20 07:51:26
Message-ID: 9F05ADB0-406C-4554-9E86-383C2B9A36B3@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> On 20 Jun 2019, at 03:07, David Marcin <david(dot)marcin(at)coinbase(dot)com> wrote:
>
> When trying to use CREATE STATISTICS on a table with child tables, the table can no longer be analyzed -- it exits with "ERROR: tuple already updated by self". I don't see any indication on https://www.postgresql.org/docs/11/sql-createstatistics.html that it should not work with table inheritance.

Thanks for reporting! This is probably the same issue which is being discussed
in this thread on pgsql-hackers:

https://www.postgresql.org/message-id/flat/20190618231233.GA27470%40telsasoft.com

cheers ./daniel

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jorge Gustavo Rocha 2019-06-20 08:48:25 Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2
Previous Message Fahar Abbas 2019-06-20 07:10:30 Re: XSS Bug in Query View