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

Поиск
Список
Период
Сортировка
От Manuel Rigger
Тема Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"
Дата
Msg-id CA+u7OA4kJ=CnPaanK94jN1KqRRHCsHWPcPdKT9LUm44=R5P5kg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ANALYZE on parent table results in an error "tuple alreadyupdated by self"  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
Thanks, and sorry for having overlooked this bug report!

Best,
Manuel

On Wed, Jul 24, 2019 at 8:00 AM Andres Freund <andres@anarazel.de> 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



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Manuel Rigger
Дата:
Сообщение: Attribute has wrong type in ALTER TABLE
Следующее
От: Manuel Rigger
Дата:
Сообщение: ADD CHECK fails for parent table if column used in CHECK is fully-qualified